Patty-
No reason you can't.
SELECT Col1
FROM Table1
UNION ALL
SELECT Col2
FROM Table1
UNION ALL
SELECT Col1
FROM Table2
UNION ALL …
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 16, 2015, at 3:01 PM, pattykf@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
quick question
can you do a normalizing union query on two different tables at the same time?
Unfortunately this Electronic health record has 5 fields on one table and 2 on another table that store same type of information on a visit for a patient. I think if I could using the normalizing union query on it, it would save me the 2 or more queries I currently have as a work around
thank you
patty
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar