Select From Multiple Tables

Basically I have 5 tables. These are...

1/ RCPCrossRef
2/ RCPPositionData

3/ RGCrossRef
4/ RGData

5/ RComments
------------------------------------------------------

RCPCrossRef and RCPPositionData are related by these keys:

RCPPositionData.UniquePositionID = RCPCrossRef.CPPositionID

RGCrossRef and RGData are related by these keys:

ON RGData.PositionID = RGCrossRef.GPositionID

-----------------------------------------------------------

RCPCrossRef and RGCrossRef are related by these keys:

ON RCPCrossRef.GMatchID = RGCrossRef.GMatchID

But RCPCrossRef may also contain a NULL value for this key meaning no relationship exists for that row.

----------------------------------------------------------------

Finally RComments is related to RCPCrossRef and RGCrossRef by these keys...

ON RComments.GPositionID = RGCrossRef.GPositionID
ON RComments.CPPositionID = RCPCrossRef.CPPositionID

But again, one of these columns in the RComments table could contain a NULL value meaning no relationship exists for that row of data.

---------------------------------------------------------------

So my aim is to display ALL DATA for each of these tables.

Tried the below but doesn't return any rows...




Code SnippetSELECT gd.Quantity, c.Comments,
gc.GPositionID, cc.CPPositionID, cd.PositionDate
FROM ReconComments AS c
INNER JOIN
RGCrossRef AS gc
INNER JOIN
RGData AS gd
ON gc.GPositionID = gd.PositionID
ON c.GPositionID = gc.GPositionID
INNER JOIN
RCPData AS cd
INNER JOIN
RCPCrossRef AS cc
ON cd.UniquePositionID = cc.CPPositionID
ON c.CPPositionID = cc.CPPositionID
WHERE gc.ForcedMatch = 'yes' AND cc.ForcedMatch = 'yes'





Thanks.