>Sorry Jim, I probably wasn't as clear as I should have been. I wanted to know how to do it ONLY using SQL code but I thought perhaps it MIGHT be doable in only in one SQL statement.

The minimum number of selects in VFP or Access is 2. However, in SQL Server it could be done in 1.