Greetings List -
I'm trying to create a UNION SELECT view from two tables and get a column
mismatch error.
Do the text columns have to be equal length?
In its simplest form, it is:
CREATE TEMP VIEW MailListl +
(LName) +
AS SELECT +
LastName +
FROM PermntResdnt +
UNION +
SELECT +
LAST1 +
FROM KarlOct08
LastName is text 64
Last1 is text 40
PermntResdnt is a working view
KarlOct08 is a table.
Once I get it working, I'll fluff it up with more cols & WHE clauses
but I want to get the basics 1st.
Thanks for your help,
Doug
RB Win 7.6.4.30919
