Help with query 1

[mcf15]

Hello.

I have table that contains ID, hostname, level1, level2, level3. I need to get the IDs that exists only in level1="users", level2="home". I know I have 29379 unique IDs in /users/home and 26997 unique IDs in all other paths except for /users/home. But I need to know which unique IDs only reside in /users/home. I am complete stuck and needed this yesterday

Thanks!!!

 

[PHV]

What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mcf15]

I've done a select distinct ID from tble where level1='users' and level2='home' to get the disctinct IDs for /users/home and select distinct ID from tble where level1 <>'users' and level2 <>'home' for distinct IDs outside of /users/home. That's it. NOt sure were to go from there. Not sure where to go from here. I need with the code. Thanks.

 

[MajP]

Select distinct 
 ID 
from 
 tble 
Where 
 level1='users' and level2 = 'home' and ID Not In (select ID from tble where level1 <>'users' and level2 <>'home')

 

[PHV]

where level1 <>'users' [!]OR[/!] level2 <>'home'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886