[Emerald] Slightly off topic

• Next message: Ronnie Franklin: "[Emerald] Emerald 4.2.1 and Post.Office 3.5.3"
• Previous message: Ronnie Franklin: "[Emerald] FW: Emerald 4.2.1"

Message-ID: <002f01c24239$1e66ae10$326468d8@fantasy>
From: "Kurt Schafer" <kahuna@cyberbeach.net>
Subject: [Emerald] Slightly off topic
Date: Mon, 12 Aug 2002 15:47:40 -0400

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 = 2)

Thanks in advance,

= K

• Next message: Ronnie Franklin: "[Emerald] Emerald 4.2.1 and Post.Office 3.5.3"
• Previous message: Ronnie Franklin: "[Emerald] FW: Emerald 4.2.1"