Unknow column 'USER' in 'where clause'.
--- Rodney Broom <[EMAIL PROTECTED]> wrote:
> From: Anthony E. <[EMAIL PROTECTED]>
>
>
> > This comes up with more records than are in
> USER_TMP.
>
> Is the 'email' column unique in both tables?
>
> Heh, sorry about that. Try this:
>
> select count(USER_TMP.email)
> from USER_TMP, USER
> where USER_TMP.email = USER.email
> and USER;
>
>
> ---
> Rodney Broom
> Programmer: Desert.Net
>
>
>
=====
--
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
