Results 1 to 3 of 3

Thread: Query Problem

  1. #1
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    28

    Question Unanswered: Query Problem

    Hi all,

    I would like to create a query of the intersection of more than 3 table, how can I do it?

    Example

    Table1
    Id Date
    2 12/01/2002
    2 02/09/2004
    6 08/09/2004

    Table2
    Id Date
    2 02/09/2004
    3 04/09/2004
    4 05/09/2004
    6 08/09/2004

    Table 3
    Id Date
    4 05/09/2004
    2 09/09/2004
    6 08/09/2004

    Both the id and date are my keys.
    And I would like to have the query having:
    Id Date
    2 02/09/2004
    4 05/09/2004
    6 08/09/2004
    How can I achieve this?
    Please help!!!

    Thanks a lot
    oks

  2. #2
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    Hi

    I don't understand what you mean by intersection and I can't see any rules that would get your output from the first three tables.

    The intersection of three sets is the data that appears in all three sets. But 4 05/09/2004 in your output doesn't appear in table 1

    Sorry if I've misunderstood something here.

    Chris

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Inner Joins ... Although with the data supplied you'll only have 1 row: 6 08/09/2004
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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