Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple Left Joins
R937 It turns out that - I was wrong, there WAS a SQL exception (but my app was sending it elsewhere where I was not looking at it) - I probably need to get glasses - I had a "." where I should have had a "," inmy list of columns to display, and whenever I added the PM.Name column I was in... -
Multiple Left Joins
R937, I simplified things somewhat to post this. There are a whole load of other columns & stuff left out for clarity. But regarding the WHERE clause, it is the same for both my scenarios and relates to items in the original PROJECTS table, i.e. is completely independent of the extra tables... -
Multiple Left Joins
I have been repeatedly failing to do something that seems like it should work. I'm trying to retrieve records from my PROJECTS table based on a WHERE but I am also usong some joins to add useful columns to the resultset. I have a table PROJECTS, that includes a "Ref" field a "Name" field...
