At 09:29 AM 8/18/2006, Kevin Roche wrote: >I think its just a matter of: > >1/ Do an Inner Join with QonQ > >2/ Do a QonQ query on the left hand table that creates an exact similar >result set with null entries for any right table fields and omits any rows >from the first query. > >3/ Do a QonQ which does a UNION of the the first two. > >You may have problems with this if the results of 1 are large and can't be >converted quickly into a list.
Well, I was hoping there would be an easier way. I guess I can import the table in DB2 into DB1 and just do a usual left join with the two tables now inside the same DB. I was hoping the QoQ syntax would allow for a left outer join, but it looks like it doesn't. :-( Thanks, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
