If the two tables are on a SQL Server you could reference the full name in your query.
SELECT T1.a, T2.b FROM database.username.tablename T1 INNER JOIN database2.username2.tablename ON ........ If this is not the case, you will need to use CF 5. At 05:05 PM 2/22/2002 -0500, you wrote: >How would I do a join of tables from two different datasources? > >Thanks, > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
