How to do inner join with 4 tables [Resolved]

Posted by Pallubhosale under Sql Server on 1/28/2014 | Points: 10 | Views : 2257 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,
how to do inner join with following 4 tables according to fileno.

table 1) Traning - Fields :FILENO,TITLE,STARTDATE,ENDDATE
table 2)Real COST- Fields :FILENO,COSTELEMENT,AMOUNT,GST
table 3)REAL_SBU- Fields : FILENO,SBU,NOPPT
table 4)REAL_COURSE_FEE -Fields : FILENO,FEECODE,FEEPERPPT

Thanks

Pallavi

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: kgovindarao523-21772 on: 1/28/2014 [Member] [MVP] Bronze | Points: 50

0	Hi, Try like this. SELECT Distinct * FROM Traning t INNER JOIN RealCOST rc ON t.FILENO=rc.FILENO INNER JOIN REAL_SBU rs ON t.FILENO=rs.FILENO INNER JOIN REAL_COURSE_FEE rf ON t.FILENO=rf.FILENO Thank you, Govind Pallubhosale, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 1/28/2014 [Member] [MVP] Platinum | Points: 25

0	SELECT t.TITLE, t.STARTDATE, t.ENDDATE, rc.COSTELEMENT, rc.AMOUNT, rc.GST, rs.SBU, rs.NOPPT, rcf.FEECODE, rcf.FEEPERPPT FROM Traning t JOIN [Real COST] rc ON t.FILENO = rc.FILENO JOIN REAL_SBU rs ON t.FILENO = rs.FILENO JOIN REAL_COURSE_FEE rcf ON t.FILENO = rcf.FILENO Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Pallubhosale, if this helps please login to Mark As Answer. \| Alert Moderator

SELECT t.TITLE, t.STARTDATE, t.ENDDATE, rc.COSTELEMENT, rc.AMOUNT, rc.GST, rs.SBU, rs.NOPPT, rcf.FEECODE, rcf.FEEPERPPT 
FROM Traning t
JOIN [Real COST] rc ON t.FILENO = rc.FILENO
JOIN REAL_SBU rs ON t.FILENO = rs.FILENO
JOIN REAL_COURSE_FEE rcf ON t.FILENO = rcf.FILENO

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Pallubhosale, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts