|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
September 12th, 2002, 04:28 AM
|
|||
|
|||
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
September 12th, 2002, 07:16 AM
|
|||
|
|||
|
Found the answer here
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > ACCESS: how to mix UNION and MAKE-TABLE queries |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
