SQL Case/Decode --> wuz RE: [thelist] ASP and PHP Correlation

[Joshua Olson]

> -----Original Message-----
> From: Luther, Ron
> Sent: Tuesday, July 27, 2004 11:22 AM

> I may look around a bit ... I've probably written this before.

Ron,

One last addition to my last post... if you make it a UNION ALL instead of a
UNION then you help yourself in two ways:

1.  The query will execute much faster because it won't try to remove
duplicates.
2.  You will probably have lots of duplicates if you are only pulling a
couple detail fields.  You probably don't want deduplication as it will
corrupt the results.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168