> The problem I'm having if I use a UNION is that the queries > use 2 different WHERE clauses. What I need to do is: > > SELECT Fields > FROM Table > WHERE Cond1 > UNION > SELECT Fields > FROM Table > Where Cond2 > > My understanding is I can only use the WHERE clause after the > last SELECT block... Your understanding is in error. You can use completely different WHERE clauses. You can only use one ORDER BY clause for the entire UNION, and you must have the same number of columns in each SELECT, and those columns have to have the same data types (or at least those data types have to be implicitly castable). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
