> > I might be missing something, but I'm not sure how unioning > > the two queries is going to help you when you get to > > displaying the records, since you'll still need some sort > > of differentiating factor at that point. > > Perhaps the two separate member queries of the UNION could > select a custom column that shows which type each record is: > > SELECT a, b, c, 'foo' AS recordtype > FROM something > UNION > SELECT d, e, f, 'bar' AS recordtype > FROM somethingElse > > Will this do the trick?
Well, yes, but at that point you could just store the differentiating factor in the collection using the CUSTOM1 or CUSTOM2 fields, and query all the collections at once. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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