Hey list,
I've been tinkering with a query the past few hours, and it's about to
drive me coconuts. It's using quite a few (messy) control statements, so
I guess I'm staring myself blind trying to solve it.
Could be a combination of that, and too much coffee.
Anyway, here's the query:
Hi Kim,
Kim Christensen wrote:
The error I get while trying executing is Unknown column
'products.product_id' in 'on clause'. Since I am selecting all
columns from that table (products), I can't really see why there's a
fuss about it!
I'm thankful for every tip I can get, and please let me
Hi,
The error I get while trying executing is Unknown column
'products.product_id' in 'on clause'. Since I am selecting all
columns from that table (products), I can't really see why there's a
fuss about it!
# SELECT products.*, manufactors.*,
# IF((
# SELECT i.supplier_id FROM