SQL Syntax Queestion

What I want to say is something like --

Select * from Households where Households.LastName, Households.FirstName IN (Select LastName, FirstName from AnotherTable by LastName, FirstName having count (*) > 1);

In other words, for any lastname+firstname combination that exists more than once in AnotherTable, I want to select the record for the same lastname+firstname combination from the "Household" table. However, this doesn't seem to do what I expect.

Do I need to do something like concatenate the two fields together in both parts of the statement?

TIA, Rog

--
roger_at__delete_this_to_reply_.martech.com