[AccessD] Outer Join - correct code

Why do you have quotes around the object and field names?  What flavor
of SQL are you using?

Charlotte Foust

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Wednesday, December 17, 2003 6:31 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Outer Join - correct code 


Group,

I need to move this part T1."EepEEID"=T3."EecEEID" from Where to From
because this need to be a Left Outer join. Not sure how to do it
properly..



from "ULTIPRO_GPF"."dbo"."EmpPers" T1, (("ULTIPRO_GPF"."dbo"."EmpComp"
T3 LEFT OUTER JOIN "ULTIPRO_GPF"."dbo"."Location" T2 on
T3."EecLocation"=T2."LocCode") LEFT OUTER JOIN
"ULTIPRO_GPF"."dbo"."OrgLevel" T4 on T3."EecOrgLvl1"=T4."OrgCode" and
1=T4."OrgLvl")

where T1."EepEEID"=T3."EecEEID" and T1."EepDateOfBirth"<'1954-01-01
00:00:00.000' and T3."EecUDField05"!='BOFA' and
T3."EecUDField05"!='HEAD' and T3."EecEmplStatus"!='T' and T3."EecEEType"
in ('REG', 'RPT', 'COM') and T3."EecDateOfOriginalHire"<'1998-01-01
00:00:00.000'  order by 2 asc, 1 asc




-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com