Good afternoon, list! I am attempting to figure out how to get the following two queries smashed into one. Both of these work very well on their own. I am not sure if this is possible, but it seems like it should be :-)
=-=-=-=-= QUERY #1 =-=-=-=-= SELECT mt.manufacturer, pt.model, rt.qty, rt.item_order, rt.description, rt.status, rt.version, if(rt.status = 'del', 0, (rt.qty * rt.this_sell)) AS sell_ttl FROM room_table rt, products pt, manu mt WHERE pt.product_id = rt.product_id AND pt.manu_id = mt.manu_id AND rt.room_id = 2 AND rt.print = 'Yes' AND rt.type = 'product' ORDER BY rt.item_order, mt.manufacturer, pt.model; =-=-=-=-= QUERY #2 =-=-=-=-= SELECT ct.manufacturer, ct.model, rt.qty, rt.item_order, rt.description, rt.status, rt.version, if(rt.status = 'del', 0, (rt.qty * rt.this_sell)) AS sell_ttl FROM room_table rt, custom ct WHERE ct.product_id = rt.product_id AND rt.room_id = 2 AND rt.print = 'Yes' AND rt.type = 'custom' ORDER BY rt.item_order, ct.manufacturer, ct.model; Both return the same number of columns with the same information type in each column, but I can't figure out how to get both integrated into one query. I have been staring at the manual long enough to make me think either this isn't possible (unlikely) or that I'm just trying to over-complicate the hell out of it (much more likely) and I'm missing some basic concept. I have tried a few things and it's beyond me at the moment... any insights would be greatly appreciated!!! Further info is definitely available if needed. Thanks! # Nathan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
