[AccessD] SQL Server - selecting preferred records

Something like this?

Select top 540000 from

(select 1 as seq, RecordPK from table1
where  (Children_0_3 and income in(XYZ)) 
or (Children_4_7 and income in(XYZ))
Order by Seq
....
UNION
select 2 as seq, RecordPK from table1
where  (Age in (1,2) and income in (ABC)))



On 4 Nov 2010 at 10:51, jwcolby wrote:

> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>