------=_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">