outer join

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi,
In my Access 2k application, one of my query need a
outer join. How to create this? I have two tables, one is
Training table with employee no, and another table is
Employee table, with employee no and employee Last Name,
First Name.... In the Training table, some of the employee
may be retired, so in the Employee table, their name won't
exist. How can I create a query with all the Training
records (even the guy retired).
I selected the Join Properties 3, which include all
records from Training table, but still missing those
retired.
Thanks for your kindly help.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It's easier to analyze your problem by seeing your SQL statement.

Anywho... how about:

SELECT T.EmployeeNo
FROM Training As T LEFT JOIN Employee As E
WHERE <criteria>

If you want all Training EmployeeNos to appear you have to use the
Training EmployeeNo in the SELECT clause, not the Employee EmployeeNo.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQJFlvYechKqOuFEgEQLOvgCg6PBLQ6nKSZ4NVMPbDbKy5gX/6KYAoObw
7dPZB6kglBSz6mWuIfKcjCFr
=5GR0
-----END PGP SIGNATURE-----
 
Back
Top