At 2:28 PM -0500 11/17/03, Peter J. Krawetzky wrote:
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
Perhaps I am missing something right in front of me, or I have not been in
the loop, but it is my understanding that MySQL does not support
sub-selects, yet.
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
BTW, you may receive lots of replies of this very nature, because it is
something
Alex,
I believe you'll find that MySQL does not support subselects. This is
why you're getting the error message. I suggest you consult the SELECT
syntax manual page (http://www.mysql.com/doc/S/E/SELECT.html) to see
what you can do with selects.
You could try to convert this into a join,
Hi Alex,
MySQL doesn't support sub-selects yet.
Gurhan
-Original Message-
From: Alex Speed [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 7:13 PM
To: [EMAIL PROTECTED]
Subject: SubSelect Problem
SELECT textid, title, description from structure where textid in (select
Ok, no support for it (d'oh), so, how do I go about breaking it down into a
join or something like that?
- Original Message -
From: Alex Speed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002 12:13 AM
Subject: SubSelect Problem
SELECT textid, title, description
On Tue, Mar 19, 2002 at 12:45:57AM -, Alex Speed wrote:
Ok, no support for it (d'oh), so, how do I go about breaking it down into a
join or something like that?
- Original Message -
From: Alex Speed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002 12:13 AM
