Results 1 to 2 of 2
  1. #1
    petrolissa is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2016
    Posts
    1

    select statement merging 4 tables with 2 i dentical columns

    urgent help needed... i have database with 10 tables. i want to fully join 4 tables which has 2 column present in all and join on the condition ofbthe 2 identical columns

  2. #2
    clindner.iv is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    8
    this happens to me all the the time.

    Write out the table and field name.

    Example.

    Id1: [Tbl_clients].[id]
    Id2: [Tbl_tasks].[id]

    by including the table/query the field is comming from it will tell access which one you intended.

    Hope that helps

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

Similar Threads

  1. Replies: 18
    Last Post: 07-01-2014, 08:18 AM
  2. Merging 2 tables
    By dusencha in forum Access
    Replies: 2
    Last Post: 02-24-2014, 11:24 AM
  3. Merging redundant columns
    By sarge89 in forum Access
    Replies: 3
    Last Post: 05-13-2013, 10:01 PM
  4. Replies: 2
    Last Post: 01-02-2012, 06:46 PM
  5. Merging 2 tables
    By todavy in forum Queries
    Replies: 4
    Last Post: 12-02-2009, 10:12 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