I think I have a generally easy SQL problem I need help with. I have a table I need to use which has the following fields: pmsid, ssn, lname, fname, rc, and budcode. Some of these fields are obvious, the others aren't important to my question.

I need to list the records in this set that have duplicate first names and last names. So if Joe Blow appears twice, I want his name to be on this list. **I also need to show the other fields in the record**. Simple so far?

I created the following SQL statement, which correctly lists the first and last names of the records in question. If I include all fields, I get no records at all. Here is what works so far:

> 
> SELECT lname, fname FROM [Employee]  
> 
>  WHERE lname != ' 'AND fname != ' '  
> 
>  GROUP BY lname, fname  
> 
>  HAVING COUNT(\*) > 1
> 
> 
> 

Then I tried to do the following to get the other fields listed, but I get an error, obviously:

> 
> SELECT \* FROM [Employee]  
> 
>  WHERE lname, fname in 
> 
> 
> 

```
(SELECT lname, fname FROM [Employee]  
WHERE lname != ' 'AND fname != ' '  
GROUP BY lname, fname  
HAVING COUNT(lname) > 1 and COUNT(fname) > 1)  

```

> 
> ORDER BY lname, fname
> 
> 
> 

I know I can't use multiple fields in the WHERE clause, but I'm not sure what else to try. Any thoughts?