error in inner joins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

error in inner joins

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-18 : 10:07:30

guduu writes "from (#createlocref ref INNER JOIN (#createdemanddtl DTL
INNER JOIN #createdemandheader HDR on DTL.demand_dtl2demand_hdr = HDR.objid AND
REF.part_trans2demand_dtl = DTL.objid) #createpartdesc des on REF.frominst2part_inst = des.objid)
LEFT OUTER JOIN #createshipdtl SDT on DTL.objid - SDT.ship_dtl2demand_dtl

I appreciate if any one can help me out in this syntax
Thanx in advance"

gpl
Posting Yak Master

195 Posts

Posted - 2004-06-18 : 12:09:25

quote:
Originally posted by AskSQLTeam

guduu writes "from (#createlocref ref INNER JOIN (#createdemanddtl DTL
INNER JOIN #createdemandheader HDR on DTL.demand_dtl2demand_hdr = HDR.objid AND
REF.part_trans2demand_dtl = DTL.objid) #createpartdesc des on REF.frominst2part_inst = des.objid)
LEFT OUTER JOIN #createshipdtl SDT on DTL.objid - SDT.ship_dtl2demand_dtl

I appreciate if any one can help me out in this syntax
Thanx in advance"

Theres something missing here - a JOIN statement see the red {??}
"from (#createlocref ref INNER JOIN (#createdemanddtl DTL
INNER JOIN #createdemandheader HDR on DTL.demand_dtl2demand_hdr = HDR.objid AND
REF.part_trans2demand_dtl = DTL.objid) {??} #createpartdesc des on REF.frominst2part_inst = des.objid)
LEFT OUTER JOIN #createshipdtl SDT on DTL.objid - SDT.ship_dtl2demand_dtl

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources