i have two tables with similar structure...
i want to find the intersection of data between two
tables that have the same email address.
I tried the following with an error (Unknown table
'USER' in where clause) the USER table is definitely
there though:
select count(email) from USER_TMP where USER_TMP.email
= USER.email;
(i want to delete entries from USER_TMP, where the
email is the same as an entrie in USER tablem, before
eventually insert data from USER_TMP into USER table).
Mysql v 3.22.32
=====
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http://chovy.com/resume.doc
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.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
