Results 1 to 2 of 2
  1. #1
    zuli007 is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    1

    Query -2 tables. Help.

    Hello!
    I making database in ACCESS 2003, and I have problem with make query.

    There is a two tables with no relationships. I want to make query which give me only records which is not in two tables at the same time.

    Example .

    Table 1.
    1
    2
    3
    4

    Table 2
    1
    2


    Query must Show me 3 and 4 from first table (it`s not in second table).



    I have access 2003 bible but i dont know how to start with this query. I tried a lot of my ideas with no results. Query show me only all records or oly this which are on two tables at the same time.


    Regards Lukas
    Sory for my english.
    Last edited by zuli007; 04-15-2010 at 06:37 AM. Reason: Solved

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Is it possible that you would have the following scenario?
    Table1
    12345

    Table 2
    34567

    Therefore needing to return 1 and 2 from table 1 AND 6 and 7 from table 2? Or does one table contain all the data from the other table and then some?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 01-29-2014, 02:45 PM
  2. Query To search Two Tables
    By stu_C in forum Queries
    Replies: 5
    Last Post: 03-25-2010, 11:50 AM
  3. Query from multiple tables
    By ambidextor in forum Queries
    Replies: 1
    Last Post: 02-25-2010, 08:01 AM
  4. combine three tables in a query
    By neuenglander in forum Queries
    Replies: 0
    Last Post: 08-21-2008, 04:02 AM
  5. Need help with tables and query criteria
    By DevintheDude in forum Access
    Replies: 0
    Last Post: 09-12-2007, 08:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums