FROM
WebUser,
Email,
[Level]
LEFT OUTER JOIN
WebUserArchive
Travis
---- Original Message ----
From: Kay Smoljak <[EMAIL PROTECTED]>
Sent: 2002-04-28
To: SQL <[EMAIL PROTECTED]>
Subject: join problem
Hi all,
I have the following SQL Server query (I've simplified it a little to
save space):
SELECT DISTINCT
WebUser.pkWebUser,
WebUser.username,
Email.email,
[Level].USD,
WebUserArchive.dtUpdated
FROM
WebUser,
Email,
[Level],
WebUserArchive
WHERE
WebUser.PartNum IS NOT NULL
AND
WebUser.fkEmail = Email.pkEmail
AND
[Level].pkLevel = WebUser.fkLevel
AND
WebUser.pkWebUser =* WebUserArchive.fkWebUser
This gives me the following error message:
The table 'WebUser' is an inner member of an outer-join clause. This is
not allowed if the table also participates in a regular join clause.
What I am trying to do is pull out ALL the matching records in WebUser,
including the field from WebUserArchive if it exists (most WebUser
records do not have a corresponding WebUserArchive record). Am I going
about this the wrong way?
Thanks,
Kay.
______________________________________________________
Kay Smoljak Web Developer PerthWeb Pty Ltd
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375
www.perthweb.com.au developer.perthweb.com.au
______________________________________________________________________
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
