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