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