Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Unanswered: All records from one table in query

    Hi,

    does anyone know how to get all records from one table to appear in a query, even if there is no match in the second table?

    i.e.

    Table 1 Table 2
    Area Sales
    North 2
    West 0
    South 4
    East 1

    Thanks for you help.

  2. #2
    Join Date
    Nov 2002
    Location
    Norway
    Posts
    239

    Smile Join Properties

    In query design view, double click the “string” between the tables.
    (Join Properties) Then it’s self explainable.

    Sincerely
    Vestigo

  3. #3
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Thanks

    Thanks for that,

    I knew it had to be something simple. I was looking at it too hard thinking it had to be SQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •