Posted by Plamen Ratchev on 09/30/82 12:00

Yes, it would have to be a LEFT OUTER JOIN, something like this:

....
FROM dbo.SAF2_Status AS S
INNER JOIN dbo.SAFs AS C
ON S.CESAFID = C.CESAFID
LEFT OUTER JOIN dbo.Instructors AS I
ON C.Inst1 = I.Inst1
....

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Max(date) using joins
• Prev in forum: Re: Biztalk vs SSIS as an ETL tool
• Thread view: Re: Max(date) using joins

[Reply to this message]