Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    11

    Unanswered: Create table from Multiple table

    Hi Experts,
    How do I create a table from multiple other tables?

    All tables have some columns.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Run append queries from all into 1 of them.

  3. #3
    Join Date
    Sep 2012
    Posts
    11
    Hi, Can you give an example please.

  4. #4
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    INSERT INTO tData ( FirstN, LastN, CoName )
    SELECT * from tbl1

    INSERT INTO tData ( FirstN, LastN, CoName )
    SELECT * from tbl2

    INSERT INTO tData ( FirstN, LastN, CoName )
    SELECT * from tbl3

Posting Permissions

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