I've not looked over your query in-depth so I may be off-base here. Try removing the parentheses from the FROM clause and see if that makes it work.
=C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Scott Raley [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 7:23 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: mysql query help I need some help... The query below runs fine in access, when running it in mysql it tells me the column wrainfo.wuc doesn't exist in the having clause.. can't figure out why its giving me this error. the column is in the select statement... any ideas? The column does exist.. I'm looking at the database right now. Query: SELECT wrainfo.wuc5, wucinfo.wuc, wucinfo.nomen, wucpartsinfo.weapon, wucinfo.refdes, wucpartsinfo.seq, parts.part_no, wucpartsinfo.tms, wucpartsinfo.sbuno, wucpartsinfo.ebuno, wucpartsinfo.lots, parts.cage, wucpartsinfo.smr, wucpartsinfo.se1, wucpartsinfo.se2, parts.niin, wucpartsinfo.changes, min(updates.updates) as udate, wrainfo.wuc as srawuc, wucpartsinfo.notea, wucpartsinfo.noteb FROM (((wucpartsinfo LEFT JOIN parts ON wucpartsinfo.parts_id =parts.parts_id) LEFT JOIN updates on wucpartsinfo.wucpn_id=updates.wucpart_id) RIGHT JOIN wucinfo on wucpartsinfo.wuc_id=wucinfo.wuc_id) RIGHT JOIN wrainfo on wucinfo.wuc5 = wrainfo.wuc5 where wrainfo.WUC5 = '46X1B' group by wrainfo.wuc5, wucinfo.wuc, wucinfo.nomen, wucpartsinfo.weapon, wucinfo.refdes, wucpartsinfo.seq, parts.part_no, wucpartsinfo.tms, wucpartsinfo.sbuno, wucpartsinfo.ebuno, wucpartsinfo.lots, parts.cage, wucpartsinfo.smr, wucpartsinfo.se1, wucpartsinfo.se2, parts.niin, wucpartsinfo.changes, wrainfo.wuc, wucpartsinfo.notea, wucpartsinfo.noteb having (wucinfo.wuc <> wrainfo.wuc) order by wucinfo.wuc, wucpartsinfo.seq --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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