ACCESS FEED: [MS_AccessPros] MAKE TABLE QUERY INVOLVING UNION QUERY

Selasa, 20 November 2012

[MS_AccessPros] MAKE TABLE QUERY INVOLVING UNION QUERY

Hello everybody

I want to write an MS Access Make Table query in order to create a table called tblMyNewTable.
This query will use records retrieved from another MS Access query described below.
Is it possible? If so, how can I make it?
Thanks in advance.
----------------------------------------------------------
SELECT tblA.name, First(tblA.address) AS FirstAdd, First(tblA.city) AS FirstCity
FROM tblA LEFT JOIN tblB ON tblA.NumInsc= tblB.NumInsc
GROUP BY tblA.name
HAVING tblA.name Is Not Null
UNION SELECT "Unknown", Null, Null
FROM tblA
ORDER BY tblA.name;