help with subquery

[mcf15]

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.



select C.CHECKSUM, C.HOSTNAME
from dbo.threeleveldirs C INNER JOIN
(select dbo.tbluserhomeonlychksums.CHECKSUM
from dbo.tbluserhomeonlychksums) AS CS
on C.CHECKSUM = CS.CHECKSUM;

 

[mcf15]

Figured it out.