#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Posts
    14
    Rep Power
    0

    Question ACCESS: how to mix UNION and MAKE-TABLE queries


    Hi people!

    I'm trying to put the result of the following request:

    SELECT 'JR' AS EMPLOYEE
    ,SUBJECT
    FROM JOEL
    UNION
    SELECT 'JC' AS EMPLOYEE
    ,SUBJECT
    FROM JOACHIM;

    into a new table, but always getting many errors...if it is possible to do that, where should I put the "into [TABLENAME]" statement?

    Thanks for your answers!
    Tiago

    ps. By the way, how should I post "code" here, I mean what are the tags to englobe code sections? html doesn't work...
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Posts
    14
    Rep Power
    0

    Found the answer here


    Very good Access FAQ site:

    http://www.kayodeok.btinternet.co.uk...ficeaccess.htm

    have fun...

IMN logo majestic logo threadwatch logo seochat tools logo