sql join query

Hi I have 3 tables.

	Code:
	Table columns -------------------------------------------------------- 1. Buy buyer,sellername 2. IM product,hdate,UOM,dept,sec,subsec 3. stud dept,sec,subsec

[code]
Required O/P with columns as :
--------------------------------------------

--------------------------------------------------
buyer product dept sec subsec
---------------------------------------------------
[code]

I wrote the query as follows

[code]
select b.buyer,iem.product,iem.dept,iem.class,iem.subsec
from buyer b,im iem,stud st
where iem.class=st.class and b.buyer in
(select buyer from buyer)

Error :
--------
I got for the same item i am getting different buyers..
So please resolve this issue.
I am not able to join BUYER table. Hope i am getting the error
at (select buyer from buyer)
so can you please help me in this issue.

Thank you.

It looks like you got bad data in your database or your SQL query is not correct

Sorry, I am not really clear what this all has to do with SQL Assistant software?