I have 3 tables I want to join together. The first 2 will always have data to show but the 3rd may or may not. I am new to joins and am not sure how to make a 3 table join where it will always show the data from the first 2 tables and only show the data in the third if there is any. Here is the code I has so far, the optional table in this case is the FilePaths table
SELECT si.SectionID, si.ShortName, si.LinkName, r.RaceID, r.RaceName, r.RaceDescription, r.RaceImagePathID, p.FilePath + p.Name AS FullPath
FROM dbo.SectionInfo AS si WITH(NOLOCK)
INNER JOIN dbo.RaceInfo AS r WITH(NOLOCK)
ON r.SectionID = si.SectionID
INNER JOIN dbo.FilePaths as p WITH (NOLOCK)
ON p.PathID = r.RaceImagePathID
--
If I get used to envying others...
Those things about my self I pride will slowly fade away.
-Stellvia
Joining 3 tables with the 3rd as optional
Posted - 05/24/2012 : 07:03:11
