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
