Query to find unmatched records help

[Bronte1226]

I am working on the following query to return results for records that are in the first table and not the second. I am fairly new to this so I am not sure where my mistake is, but I keep getting this syntax error.

"Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '.'."

I would greatly appreciate insight...I must have messed up somewhere...

SELECT CUDAddress, CUDName
FROM (
SELECT A.CUDAddress, A.CUDName,
B.OutAddress as BOutAddress
from CUD A
left outer join Outliers
A.CUDAddress = B.OutAddress and
A.CUDName = B.OutName
) FOO
WHERE BOutAddress IS NULL

 

[SQLSister]

You forgot to alias B
but wouldn't this do the same thing?

   SELECT A.CUDAddress, A.CUDName
   from CUD A
   left outer join Outliers B
      A.CUDAddress = B.OutAddress and
      A.CUDName = B.OutName
WHERE B.OutAddress IS NULL

"NOTHING is more important in a database than integrity." ESquared