Could someone please tell me what is wrong with this query: select * from personnel where dept_id not in (select dept_id from attendance_respond)
I keep getting a 1024 error message. It looks pretty straightforward to me. I am running 4.0.16 on Redhat Linux 8. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]