Basic "JOIN" Function -- Please Reply

  • The following displays just "Jane Doe",

    however I want it to display all customers

    and then their passwords if they have one

      SELECT     customers.number, customers.name, xref.details

      FROM         customers LEFT OUTER JOIN

                          xref ON customers.number = xref.number

      WHERE     (xref.type = 'pass')

    ------------------------------------------

    The following displays all customers,

    however it makes the password column identical for

    both which is wrong since John Doe password = blank

      SELECT     customers.number, customers.name, xref.details

      FROM         customers LEFT OUTER JOIN

                          xref ON customers.number >= xref.number

      WHERE     (xref.type = 'pass')

    ------------------------------------------

    Please let me know if you want me to email

    the 100k MDB file to you for testing purposes.

    CUSTOMER dataset

      number    name

      1            Jane Doe 

      2            John Doe 

     

    XREF dataset

      number     type    details

      1             email   126@a.com

      1             pass    goodfood 

      2             email   42@e.com 

    ------------------------------------------

    End Result that I need:

    number         name         details

    1                Jane Doe     goodfood 

    2                John Doe  

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply