Query Not Workin, Help!

[lkevinc42036]

I have three tables, two of which are linked to a field in the third table. I am trying to create a query that displays data from table 1 with its respective data from table 2. However, my query will show all the data I want from table 1, yet the part I need from table 2 remains blank. Does anybody know what I need to fix? I suspect it's a problem with the relationships.

[JoeM]

Please post the SQL code of the query you tried building (if you switch to SQL View, you can copy and paste the SQL code here).

[lkevinc42036]

SELECT [Parameter Table].[Parameter Name], [CPNPP FSAR SOFs1 fixed].[FSAR SOF Number], [Parameter Table].ID, [Parameter Table].[LSD Number and Rev], [Parameter Table].[Parameter Owner], [LSDs & OWNERS_OLD].[LSD Number and Rev]
FROM [Parameter Table] LEFT JOIN ([CPNPP FSAR SOFs1 fixed] LEFT JOIN [LSDs & OWNERS_OLD] ON [CPNPP FSAR SOFs1 fixed].[LSD Number and Rev] = [LSDs & OWNERS_OLD].[LSD Number and Rev]) ON [Parameter Table].[LSD Number and Rev] = [CPNPP FSAR SOFs1 fixed].[LSD Number and Rev];