JOIN problem

JOIN problem

El Forum
Guest

01-08-2010, 07:52 AM

[eluser]wowdezign[/eluser]

Quote:I tried the left join as you explained a few posts ago. That didn’t work. I then tried changing the join around and I get the same exact result.

Did you switch the query order AND use the LEFT JOIN at the same time?
Because there is a difference between using JOIN and LEFT JOIN.

It would be easier for us to test our suggestions if we had the CREATE statement to generate the empty tables with.

Messages In This Thread

JOIN problem - by El Forum - 01-07-2010, 03:12 PM

JOIN problem - by El Forum - 01-07-2010, 03:55 PM

JOIN problem - by El Forum - 01-07-2010, 04:00 PM

JOIN problem - by El Forum - 01-07-2010, 04:03 PM

JOIN problem - by El Forum - 01-07-2010, 04:07 PM

JOIN problem - by El Forum - 01-07-2010, 08:22 PM

JOIN problem - by El Forum - 01-07-2010, 09:29 PM

JOIN problem - by El Forum - 01-07-2010, 10:39 PM

JOIN problem - by El Forum - 01-08-2010, 07:52 AM

JOIN problem - by El Forum - 01-09-2010, 12:18 AM

JOIN problem - by El Forum - 01-09-2010, 01:55 PM

JOIN problem - by El Forum - 01-09-2010, 02:18 PM

JOIN problem - by El Forum - 01-10-2010, 10:34 AM

JOIN problem - by El Forum - 01-10-2010, 10:43 AM