September 12th, 2002, 05:28 AM
ACCESS: how to mix UNION and MAKE-TABLE queries
I'm trying to put the result of the following request:
SELECT 'JR' AS EMPLOYEE
SELECT 'JC' AS EMPLOYEE
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!
ps. By the way, how should I post "code" here, I mean what are the tags to englobe code sections? html doesn't work...
September 12th, 2002, 08:16 AM