Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Prakash Mondal
1.8k
230
141.6k
Joining Problem
Dec 7 2017 4:40 AM
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
Reply
Answers (
1
)
Entity framwork production deployement
Procedure or function has too Argument Specified