guess it was lost...so here ya go dharmesh
sure, basically, i had to run it from query analyzer, could not run it from
inside ent. mgr...had to fully qualify each db.owner.table
<table names have been changed :)>
SELECT u.[ID] As MyID, c.customer_id As YourCustID, u.Email
FROM table_one.dbo.Users u, table_two.dbo.new_customer c
WHERE u.Email = c.acct_email
~~
Stephenie Hamilton
Senior ColdFusion Administrator
Express Technologies, Inc.
want CF_Freedom?
try CFXHosting.com
Winner of the 2000 ColdFusion Developer's Journal Best ColdFusion Web Host!!
-----Original Message-----
From: Dharmesh Goel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 1:37 PM
To: CF-Community
Subject: RE: ack - never mind
Hi Stephenie,
Could you please share a sample query on how you managed this?
Thanks,
Dharmesh Goel
Programmer Analyst
IT Dept. - Discount Car & Truck Rentals
416-744-0123 x290
-----Original Message-----
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]]
Sent: June 7, 2001 12:25 PM
To: CF-Community
Subject: ack - never mind
figured it out (joining 2 tables in 2 seperate db's)
<nothing like clogging up the mail server for nothing!>
~~
Stephenie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
