B
Bruce Hartsell
Running Access 2003 ---
I want to take the last names from a table called "Committee Members" and
the last names from a table called "Faculty&Staff" and put them together in
one list.
I tried the following SQL, which returned only the names from the "Committee
Members" table.
SELECT [CMLName]
FROM [Committee Members]
UNION SELECT [Last Name]
FROM [Faculty&Staff]
What did I do wrong?
--
Thanks,
Bruce Hartsell
Department of Social Work
California State University
Bakersfield, CA
I want to take the last names from a table called "Committee Members" and
the last names from a table called "Faculty&Staff" and put them together in
one list.
I tried the following SQL, which returned only the names from the "Committee
Members" table.
SELECT [CMLName]
FROM [Committee Members]
UNION SELECT [Last Name]
FROM [Faculty&Staff]
What did I do wrong?
--
Thanks,
Bruce Hartsell
Department of Social Work
California State University
Bakersfield, CA