October 25th, 2004, 03:13 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL MS access coldfusion query
Can anyone tell me how I would add to the following working query another "join" condition. ie: what is the syntax
That join condition is
This is using coldfusion's SQL trying to access an MS access database.
Thanks
Code:
<cfquery name="GetCMbyEmail" DATASOURCE="#DS#">
SELECT main.CMNumber, main.NotificationList, main.CompIs
FROM (main INNER JOIN notify ON main.notificationList = notify.email)
INNER JOIN login ON notify.fullname=login.fullname
WHERE login.fullname like '%#form.fullname#%'
</cfquery>
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
