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
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
