Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    Saudi Arabia
    Posts
    9

    Unanswered: How can I combine two tables in Access?

    Hi all

    I have two tables I need to merge them in one query.

    The problem is that I need to have all the records in the new table without dublication. How can I do that?

    Regards,

    dallagmm

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    investigate a the join clause in SQL
    investigate the distinct / distinctrow clause in SQL

    withou more details its hard to gie clear pointers, however the join and distinct sub clauses of SQL should get you close to what you want
    HTH

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    This sounds a bit funny... your tables don't have identicle structures do they?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Jan 2005
    Location
    Western MA
    Posts
    6
    Use a Union between the two tables. You must have identical fields in each to do this union though. Enter SQL SELECT statements combined with either the UNION operation if you don't want to return duplicate records or the UNION ALL operation if you do want to return duplicate records.

Posting Permissions

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