Re: join with 1 row limit - Mailing list pgsql-novice

Try:

SELECT * FROM products p LEFT JOIN products_images pi ON p.id = pi.product_id WHERE products.company = 7 LIMIT 1;

On Jan 15, 2011, at 8:02 AM, Behringer Behringer wrote:

> SELECT *
> FROM
> products p LEFT JOIN
> products_images pi ON p.id = pi.product_id  LIMIT 1
> WHERE products.company = 7

Thanks & Regards,
Vibhor Kumar