Behringer Behringer <behringerdj@yahoo.com> writes:
> In mysql this query works fine, what is the equivalent in posgresql?
> SELECT *
> FROM
> products p LEFT JOIN
> products_images pi ON p.id = pi.product_id LIMIT 1
> WHERE products.company = 7
When asking that sort of question, it would be a good idea to explain
exactly what you expect that syntax to do. Not all of us know every
nook and cranny of mysql's nonstandard behaviors.
regards, tom lane