I'm sure there's a lot of group list, blog, etc chatter on
cross-database joins depending on your db platform.
Once you get it working directly (via Query Analyzer, Management Studio,
dbVisualizer, SQL Explorer, TOAD, etc...), then just transfer the script
into a CFQUERY tag.
Now, if your platform won't support this kinda thing, you COULD make
your first database call, then make the second one and use the CF query
functions to manually build the complete result set you need. But this
is taxing and not recommended for volume stuff. I suppose In some
situations you can cache a "superset" and than make short queries
against it as needed.
Al
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
official manual: http://www.openbluedragon.org/manual/
Ready2Run CFML http://www.openbluedragon.org/openbdjam/
mailing list - http://groups.google.com/group/openbd?hl=en
