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: http://pastebin.perl.se/b6e5b7f1cb/ 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 know if you want to see the table layouts. Best regards -- Kim Christensen "With insomnia, you're never really asleep; you're never really awake." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]