[AccessD] SQL Server - selecting preferred records

jwcolby jwcolby at colbyconsulting.com
Thu Nov 4 09:51:48 CDT 2010


I have a query where I need to select sets of records:

(Children_0_3 and income in(XYZ))
(Children_4_7 and income in(XYZ))
.
.
etc.
(Age in (1,2) and income in (ABC))

I need to select the first group, then the next etc until I total 540K records.

Basically I need to select the records with something in any of the Children_X_Y fields
and after that select from the last group.

Is there a way to do that directly in SQL?


-- 
John W. Colby
www.ColbyConsulting.com



More information about the AccessD mailing list