not sure if you can. but you can query one DB then populate the results in a temp table in the other DB "Eli Shechter" <[EMAIL PROTECTED]> wrote: Hi I recently started using a program that runs off a oracle database, and my website runs off SQL server 7.0 how can I run a query so that within one query I can pull data from both databases? Thank You Eli Shechter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists