Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to merge data from 2 tables using a common identifier

Discussion in 'Information Technology' started by duclosa, Jul 28, 2006.

  1. duclosa

    duclosa
    Expand Collapse
    Guest

    Hello.

    I have 2 tables (say A and B) with contains a number of fields. There is 1
    field common to both tables. I want to extract 2 fields from table B and put
    them in table A. Can someone help me? There must be an easy way to do that,
    but I'm a newbie...
    thanks.
    alain
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Look at the QBE grid. Click on Queries ... New and add tables to the grid.
    Link the 2 tables on their common field, by dragging one to the other. Add
    the fields to the table, and run the query.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "duclosa" <duclosa@discussions.microsoft.com> wrote in message
    news:193E46AE-6CE4-4E57-989F-02CC256C8A9B@microsoft.com...
    > Hello.
    >
    > I have 2 tables (say A and B) with contains a number of fields. There is 1
    > field common to both tables. I want to extract 2 fields from table B and
    > put
    > them in table A. Can someone help me? There must be an easy way to do
    > that,
    > but I'm a newbie...
    > thanks.
    > alain
     
  4. Jamie Collins

    Jamie Collins
    Expand Collapse
    Guest

    duclosa wrote:
    > I have 2 tables (say A and B) with contains a number of fields. There is 1
    > field common to both tables. I want to extract 2 fields from table B and put
    > them in table A. Can someone help me?


    You are describing a JOIN, one of the fundamentals of SQL.

    > There must be an easy way to do that,
    > but I'm a newbie...


    May I then suggest:

    http://sqlcourse.com/

    Jamie.

    --
     

Share This Page