Riza-frasin...
---
Rodney Broom
Programmer: Desert.Net
> Your message cannot be posted because it appears to be either spam...
> database,sql,query,table
> From: Anthony E. <[EMAIL PROTECTED]>
>
> > Unknow column 'USER' in 'where clause'.
>
> D'oh! Fast fingers and too many thoughts.
>
>
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
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 Br
On Friday 07 September 2001 23:37, Anthony E. wrote:
> 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
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 wher