Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    5

    Unanswered: Multiple append query

    I have two tables, COLLEGE and UNIVERSITY. The table structures and Data are follows,

    COLLEGE

    STUDID STUDNAME COURSE
    1 A A
    2 B B
    3 C C
    4 D D
    STUDID is the primary Key and it has 3 column like STUDID STUDNAME and COURSE

    UNIVERSITY
    COLLEGEID STUDID STUDNAME COURSE

    combination of COLLEGEID and STUDID is a primary Key.

    Now i want to append the data from COLLEGE table to UNIVERSITY Table as,
    COLLEGE ID STUDID STUDNAME COURSE
    1 1 A A
    1 2 B B
    1 3 C C
    1 4 D D

    In MS-Sql i used this query, "insert into UNIVERSITY SELECT 1,* FROM COLLEGE"

    What is the respective query for MS-Access to achieve the same.
    Thanks for help..
    Gururaj k

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and what happens if you try the same query in Access?
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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