Why does this query work in mySQL 4.1 and not mySQL 5.

Hi,

Can anyone help me to why the query below works perfectly in mySQL 4.1.21 and falls over in version 5.0.51 with the following SQL error:

		SELECT 	og.*,
				s.title AS shippingTitle,
				u.fullName, u.pkUserId				
		FROM dordergroups og, dusers u
		LEFT JOIN dshipping s ON og.fkShippingId = s.pkShippingId
		WHERE og.fkUserId = u.pkUserId
		AND og.pkOrderGroupId = 124765 

Code (markup):

Any help would be greatly appreciated!

Thanks

 

Just found this:

http://dev.mysql.com/doc/refman/5.0/en/join.html

It seems they have changed the syntax in v5 (grrrr). Can anyone help to see what the query should be now?

 

I am having the same issue. You get something running smoothly and bam. Change of version!

 

Try this:

		SELECT 	og.*,
				s.title AS shippingTitle,
				u.fullName, u.pkUserId				
		FROM (dordergroups og, dusers u)
		LEFT JOIN dshipping s ON og.fkShippingId = s.pkShippingId
		WHERE og.fkUserId = u.pkUserId
		AND og.pkOrderGroupId = 124765 

Code (markup):