> 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
On Mon, Dec 29, 2008 at 10:17 AM, Keith Spiller wrote:
> Another option that would work if I can figure out the correct syntax is to
> just NULL certain values if a given condition exists. If
> product_type='course' then just use the o.product_id value for field4. If
> product_type != 'course' t