Can't you do some linked tables something or another with SQL Server 2k - link tables between DBs? Maybe I am thinking in the Oracle world again.... --b Bryan Batchelder Web Application Developer ConnectWise, Inc. Phone: 813-935-7100 x 425 Email: [EMAIL PROTECTED] > -----Original Message----- > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 01, 2001 2:41 PM > To: CF-Talk > Subject: RE: JOIN queries from two datasources > > > You need CF5's Query a query feature for this > > -----Original Message----- > From: Diana Nichols [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 01, 2001 1:52 PM > To: CF-Talk > Subject: JOIN queries from two datasources > > > Sorry if this has been asked before.... > > Can I join two queries from two different datasources (SQL 2000)? > > I need to relate the username/userID from source 1 to userID > from source 2. > > (If it's too difficult, I'll just copy the username into source 2). > > TIA! > > D > > ************* > Diana Nichols > Webmistress > http://www.lavenderthreads.com > 770.434.7374 > > "One man's magic is another man's engineering." ---Lazarus Long > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
