Wednesday, March 26, 2014

SP Help like full outer join 



 
select q.QNumber, d.DNumber 
from QuotationDN qd 
full join Quotation q on qd.qid=q.id
full join DeliveryNote d on qd.qid=d.id



The last line should be qd.did 



full join DeliveryNote d on qd.did=d.id

~J


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)