Roberto, I would suggest a similar series of steps but the link gives a rather complex example since they are trying to write a generic version that works out foir itself waht the queries are. If you do it yourself it may be easier to understand, and it may be possible to make it perform better.
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. Kevin -----Original Message----- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: 18 August 2006 12:58 To: CF-Talk Subject: RE: Query of Queries - showing all entries from DB1 At 07:30 AM 8/18/2006, you wrote: >I think with a query of queries, you can do a left outer join using "*=" >syntax: > >SELECT > * >FROM > table1, > table2 >WHERE > table1.id *= table2.fkey > >I AM NOT SURE OF THIS. But I think I read it somewhere. Thanks for the input. I tried it, but CFMX did not like the syntax (I'm using Access, if that makes a difference). I found a link to a "fake left outer join" script at http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of ..html A left outer join sound just like what I need to do. Is there an easier way to do it (easier than what is described in the link above)? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:250287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
