3.23 to 4.x?
Try changing "JOIN list_states " to "INNER JOIN list_states "
Looks like the earlier version didn't like your (synonymous) wording.
> -Original Message-
> From: Jack Dare [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 14, 2003 8:35 AM
Is there something about 3.23 that makes this illegal? It is fine on 4.012.
SELECT [lots of columns]
FROM new_people p LEFT JOIN new_address ad ON p.address_id = ad.id
JOIN list_states ls ON ad.state = ls.id
WHERE p.company_id = 1
Will some minor rewording help it run on both versions OK?
--
M
