I believe that using union will cause even more database load than making the queries on a separate basis. This is because the union instruction does an implicit distinct which in this case you just don't need.
You could use "union all" instead but, anyway, this would end up using the same database resources than the 4 queries separately.
02-25-2008, 02:08 AM
Threaded Mode