Joining Problem

Question

Suppose Table: stu_mas, stu_fees_mst, stu_fees_details

 

stu_mas:

stu_id	stu_name
STU-1001	RABIN PANDAY

 

stu_mst

recpt_id	stu_id	total
R-1001	STU-1001	5000

 

stu_fees_details

recpt_id_pk	slno	fees	purpose
R-1001	1	4000	admission fees
R-1001	2	1000	library fees

Output will happen:

 

stu_id	stu_name	recpt_id	slno	fees	purpose
STU-1001	RABIN PANDAY	R-1001	1	4000	admission fees
STU-1001	RABIN PANDAY	R-1001	2	1000	library fees

 

Query is:

 

selec * from

( select * from stu_fees_details where recpt_id_pk in(select recpt_id from stu_mst) ) as a

left join (select * from stu_mst) as b on a.recpt_id_pk=b.recpt_id

left join

(select * from stu_mas) as c b.stu_id=c.stu_id

 

But display ERROR.

 

Please solve this