Re: Re: intersection: join query...

2001-09-07 Thread Rodney Broom
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. > >

Re: intersection: join query...

2001-09-07 Thread Anthony E.
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

Re: intersection: join query...

2001-09-07 Thread Rodney Broom
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

Re: intersection: join query...

2001-09-07 Thread Ian Barwick
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

intersection: join query...

2001-09-07 Thread Anthony E.
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