You are the man...thanks a bunch! that's what I needed.
=============================
r a n d y / sesser at mac.com
> From: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Date: Fri, 6 Jul 2001 14:39:59 +0800
> To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL" <[EMAIL PROTECTED]>
> Subject: Re: Syntax question for a beginner..
>
> Well, if you are combining the 2 tables like that into 1, then there is an
> easier way without the need for an array.
>
> Make sure you have a unique index on email for tableA and then
>
> INSERT INTO tableA(email) SELECT email FROM tableB
>
> The unique index will stop the duplication while adding values that are in B
> but not in A.
>
> ----- Original Message -----
> From: "{ randy }" <[EMAIL PROTECTED]>
> To: "MySQL" <[EMAIL PROTECTED]>
> Sent: Friday, July 06, 2001 14:05
> Subject: Re: Syntax question for a beginner..
>
>
>> Well, I think I got it figured out. I am using PHP, and thought I could
> lick
>> it with just one query...not so. I guess nested selects can be done in
>> mssql. Anyway, here is what I did...basically:
>>
>> SELECT tableA.email FROM tableA,tableB WHERE tableA.email = tableB.email;
>> Loaded that into an array[email]
>> Looped
>> DELETE FROM tableA WHERE email LIKE 'array[email]';
>> Then
>> SELECT email FROM tableA; # into another array[email]
>> Then
>> Looped
>> INSERT INTO tableB (id, email) VALUES('','array[email]');
>>
>> That should do it I think
>>
>> Thanks for the help though...now I know you can't do nested selects :\
>>
>> - randy
>> =============================
>> r a n d y / sesser at mac.com
>>
>>> From: "Rolf Hopkins" <[EMAIL PROTECTED]>
>>> Date: Fri, 6 Jul 2001 13:57:27 +0800
>>> To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL" <[EMAIL PROTECTED]>
>>> Subject: Re: Syntax question for a beginner..
>>>
>>> Even if sub-selects were available in MySQL (which they're not), that
> query
>>> would still not work as it will only select the values that are unique
> to
>>> tableA.
>>>
>>> What you would be looking at is something like:
>>>
>>> SELECT email
>>> FROM tableA
>>> UNION
>>> SELECT email
>>> FROM tableB
>>>
>>> But unfortunately, UNION is not available yet either. The next best
> thing
>>> that I can think of is to create a temporary table with the email column
>>> having a unique index and first add the contents of tableA and then
> tableB.
>>> Finally, you can then retrieve all values from the temporary table which
>>> contains all values from both tableA and tableB, without the duplicates.
>>>
>>> ----- Original Message -----
>>> From: "{ randy }" <[EMAIL PROTECTED]>
>>> To: "MySQL" <[EMAIL PROTECTED]>
>>> Sent: Friday, July 06, 2001 12:28
>>> 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
>
---------------------------------------------------------------------
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
