Select .. IN query needs a little help
Posted on 2005-04-28
I am trying to build a query where we are looking for people who have not yet logged in. The users are tied to a master group entity, so there is 3 tables involved here.
Group owns child Providers, only the Providers can have logins. So, we are trying to lookup, by parent ProviderGroup, which child logins have not visited our system yet. Right now the syntax of the query isn't quite right ( maybe the logic is wrong .. but I think just the syntax )
WHERE ((Users.LoginSuccess > 0) AND (Users.UserTable = 'Provider') AND (Users.UserTableID = Provider.ProviderID)) IN
WHERE Provider.ProviderGroupID = )