Re: outer join

From: MGFoster (me_at_privacy.com)
Date: 04/29/04

  • Next message: Kate: "DoCmd.RunSQL error Help" 
    Date: Thu, 29 Apr 2004 20:29:46 GMT

    -----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-----
paul wrote:
> 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.
  • Next message: Kate: "DoCmd.RunSQL error Help"

    Relevant Pages

    • Re: ADP Help
      ... employee selection form, selecting a single employee from the combo box, ... SQL statements are on the SQL Server, how would the SQL statement know how ... I use that query as a base query ... >> Randel Bjorkquist ...
      (microsoft.public.access.adp.sqlserver)
    • RE: How to code/perform a search
      ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... use a text box to capture search criteria from the user. ... The After Update event is to ...
      (microsoft.public.access.formscoding)
    • RE: How to code/perform a search
      ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Dave Hargis, Microsoft Access MVP ... use a text box to capture search criteria from the user. ...
      (microsoft.public.access.formscoding)
    • RE: How to code/perform a search
      ... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Initially, the form was unbound, but then I could not enter the ... use a text box to capture search criteria from the user. ...
      (microsoft.public.access.formscoding)
    • RE: How to code/perform a search
      ... When I read your response, about 50% of it makes sense to me. ... use a text box to capture search criteria from the user. ... record from the query. ... The form has objects for each column in the employee table. ...
      (microsoft.public.access.formscoding)