I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
a.local_stock = 'y' || a.is_commercial =
'n' || freight_class = '', 'y', 'n'
) as local_stock,
a.productid = b.productid
) > 1, 'y', 'n'
) as price_breaks,
a.productid in (select c.productid from
variants c), 'y', 'n'
) as is_variant,
a.forsale = 'N', 'y', 'n'
) as disabled,
d.orderid = e.orderid
) > 0, d.date, 0
) as last_sold
The query is erroring out on 'd.date' in expression two of the if
statement, "#1109 - Unknown table 'd' in field list". Is there a way I
can do a IF((SELECT.....), expr2, expr3) and have expr2 populate with
whatever is returned from the select statement? Thank you.
John C. Nichel IV