query to find the column value in another table

CREATE TABLE #FreeSpace
    (
      Drive CHAR(1) ,
      MB_Free INT
    )

INSERT  INTO #FreeSpace
        EXEC xp_fixeddrives;

SELECT  *
FROM    #FreeSpace a
WHERE   EXISTS ( SELECT 1
                 FROM   sys.database_files
                 WHERE  physical_name LIKE a.Drive + '%' ) ;

---

sqldevelop.wordpress.com