Re: [PHP-DB] IF Clause in Left Join

2008-12-29 Thread chris smith
I really need some help. I'm trying to use an IF statement in a multi-table left join. I'm joining four tables (customers, contents, courses locations). IF can only be used in the select part or the where part, it can't be used in the join part of a query. In the contents table I have two

[PHP-DB] IF Clause in Left Join

2008-12-28 Thread Keith Spiller
Hi, I really need some help. I'm trying to use an IF statement in a multi-table left join. I'm joining four tables (customers, contents, courses locations). In the contents table I have two fields, product_id and value_id that relate to different values in different tables depending upon