[thelist] can / should this be done in SQL?

[Edward McCarroll]

I don't know about MySQL, but I've actually used the following in
MS SQL Server:

  select top 2 * from ActivityOrganizer where OrganizerTypeId = 1
  union
  select top 3 * from ActivityOrganizer where OrganizerTypeId = 4
  union
  select top 5 * from ActivityOrganizer where OrganizerTypeId = 9
  order by ActivityId

The "order by" comes last because it applies to the entire union.

Regards,

  Ed

"Expletive Deleted!" (Richard M. Nixon)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                                     Ed at ComSimplicity.com
PO Box 654                                             (310) 904-3651
Culver City, CA 90232                           www.ComSimplicity.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  

> I tried:
> 
> SELECT * FROM news WHERE category = 1 ORDER BY date DESC LIMIT 4
> UNION
> SELECT * FROM news WHERE category = 2 ORDER BY date DESC LIMIT 3
> UNION
> SELECT * FROM news WHERE category = 6 ORDER BY date DESC LIMIT 3
> UNION
> SELECT * FROM news WHERE category = 3 ORDER BY date DESC LIMIT 2
> 
> Which gives me an error 'Incorrect usage of UNION and ORDER BY'