On Tue, Apr 22, 2008 at 2:10 PM, Kenneth Dombrowski <[EMAIL PROTECTED]> wrote: > SELECT > p.id , > p.price , > IF(d.description, d.description, en.description) AS description , > IF(d.lang_id, d.lang_id, en.lang_id) AS lang_id > FROM product AS p > INNER JOIN user AS u ON u.id = :1 > LEFT JOIN description AS d ON ( > d.product_id = p.id > AND d.lang_id = u.lang_id > ) > LEFT JOIN description AS en ON ( > en.product_id = p.id > AND d.lang_id = 'en' > ) > WHERE p.category = :2
That is perfect... I feel dumb now. Is there any reason IF is preferable to COALESCE? Regards, John Campbell _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
