LEFT JOIN problem

[Square1]

Hi all:

When I run a query using a LEFT JOIN I am expecting to see results for all items from the "Left" table but instead these results are still depending on a value in the "RIGHT" table.

Here is a portion of the query:

FROM SHL_Events
	INNER JOIN SHL_Players ON SHL_Players.plID = SHL_Events.plID
	[COLOR="Red"]LEFT JOIN SHL_PlayerDetails ON SHL_PlayerDetails.plID = SHL_Events.plID[/COLOR]
	INNER JOIN SHL_Promoters ON SHL_Promoters.prID = SHL_Events.prID
	INNER JOIN SHL_Sports ON SHL_Sports.sportCode =  SHL_Players.sportCode
	INNER JOIN SHL_Locations ON SHL_Locations.loID = SHL_Events.loID

Right now, if I do not have a record in PlayerDetails that has a matching plID to the record in Events the result will not appear. As a LEFT JOIN I want this record to appear from Events regardless of there being a record for it in PlayerDetails.

I have tested this by adding a dummy record in PlayerDetails for results that should be appearing and once the record is added, they do appear.

Any help appreciated!

[bradgrafelman]

Have you tried moving that LEFT JOIN above the INNER JOIN above it?

[Square1]

Thanks Brad, but it is still the same.

To complicate things a bit, I am running essentially the same query elsewhere (with a WHERE variation) and it is working fine.

[Square1]

Through a lot of luck and looking for haystack needles it turned out to be related to the WHERE portion of the query.

Thank you