I was able to use some sample data to create a simple Left Join and got results using 2 different databases. Thank you. I learned something.
I need to learn more though. Here's kinda pseudo-code for what I need to end up with: I need the results of my first query to get the data for the intermediate query and that resulting data to use in the last query from the other database. Then I need to fold the results of the last query into the data from the first query. That query result is then used in in existing code to build an array with structures. The input into the array depends on what the results need to be sorted on as well as populate the search results to display. It was fine to sort by document name, but after writing all the code and delivering it to the customer, he now wants to sort on Source Title, which is not fine since I need to join some data from the Sources table with its matches in the Facilities table to get the SourceTitle data for those Sources (The other Source records already have sourceTitle's from admin form entries that are not Facilities.) Ultimately, I need all the SourceTitle fields populated in the first query result. Then I can sort by SourceTitle. The first query is what gave me all the rows I need. (I didn't put the Facility sourceTitle names in the Sources table when the Source table is being populated by admin form entries b/c the Facility information may change so I always have to go to the Facilities table in the other database to get Facilities data.) Maybe this is too much information? I appreciate any light you can shed on this. Thanks much! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
