Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
help with subquery
Hello. I have 2 tables: dbo.threeleveldirs and tbluserhomeonlychksums I need get data from the dbo.threeleveldirs table where dbo.threeleveldirs.checksum = tbluserhomeonlychksums.checksum. I tried several ways but no luck. Below is the latest query. The query doesn't return any records...- mcf15
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Help with query
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...- mcf15
- Post #3
- Forum: Microsoft: Access Forms
-
Help with query
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...- mcf15
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
