You might try using a UNION statement which afaik is available both in a db query and in a CF5/MX query of query...
SELECT column1 FROM TABLE1 UNION SELECT column2 AS column1 FROM TABLE2 etc... I've noticed that with QofQ and some other query manipulation I sometimes see errors related to data-type... I think that somehow a cfquery which draws from a database is internally typed ( within cf ) whereas manually generated queries contain _only_ varchar fields due to CF's non-typed variables... Or at least, this is the impression I've gotten from the error messages I've seen. hth Isaac www.turnkey.to 954-776-0046 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
