[Emerald] Slightly off topic

Kurt Schafer ( (no email) )
Mon, 12 Aug 2002 15:47:40 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_002C_01C24217.9748D910
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a table containing Login names that I want to compare with =
SubAccounts. In particular, I want to pull a list of 'Login's from =
Table1 where the Login is NOT located in SubAccounts. (with an extra =
criteria check in SubAccounts also)

This is the query I'm running, which returns 0 results. (which is =
incorrect, there should be some matches)

Can somebody help me out ?

SELECT Login FROM Table1 WHERE Login NOT IN (SELECT Login FROM =
SubAccounts WHERE DomainID =3D 2)

Thanks in advance,

=3D K

------=_NextPart_000_002C_01C24217.9748D910
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

I have a table containing Login names =that I want=20to compare with SubAccounts. In particular, I want to pull a list of ='Login's=20from Table1 where the Login is NOT located in SubAccounts. (with an =extra=20criteria check in SubAccounts also)
 
This is the query I'm running, which =returns 0=20results. (which is incorrect, there should be some matches)
 
Can somebody help me out ?
 
SELECT Login FROM Table1 WHERE Login =NOT IN (SELECT=20Login FROM SubAccounts WHERE DomainID =3D 2)
 
Thanks in advance,
 
=3D K
------=_NextPart_000_002C_01C24217.9748D910--