I had never seen "WHERE NOT" before.
Does this exist in mysql????
siomara
>From: Shania Qiu <[EMAIL PROTECTED]>
>To: '{ randy }' <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: RE: Syntax question for a beginner..
>Date: Fri, 6 Jul 2001 16:39:47 +1200
>
>I remember somewhere has mentioned that MySQL does not copy with nested
>SELECT query. Properly it is the reason.
>
>
>Shania Qiu
>
>
>-----Original Message-----
>From: { randy } [mailto:[EMAIL PROTECTED]]
>Sent: Friday, 6 July 2001 4:29 p.m.
>To: MySQL
>Subject: Syntax question for a beginner..
>
>
>Alright, I am about to pull my hair out.
>
>I have 2 tables. Each have a column 'email' that are unique. Some of the
>records in both tables are duplicates and I want to combine the two tables
>into one with out bringing in the duplicates. So...
>
>I have this statement:
>Mysql> SELECT email FROM tableA WHERE NOT (email IN(SELECT email FROM
>tableB));
>
>Now, this gives me an error at the second SELECT. I have been trying
>different ways, but no go. I got the general syntax from a friend, but I
>could not get it to work. Is my syntax just wrong?
>
>mysql Ver 11.13 Distrib 3.23.36, for -freebsd4.3 (i386)
>
>Any help would be appreciated,
>- randy
>
>
>P.S.
>Fist time poster, first time lister :)
>=============================
>r a n d y / sesser at mac.com
>
>
>---------------------------------------------------------------------
>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
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
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
