Doug, Put Last1 in parentheses in the second select, so that it's an expression, and R:BASE will magically cast it into the same size text as LName.
Bill On Thu, Nov 6, 2008 at 9:41 PM, Doug Hamilton <[EMAIL PROTECTED]> wrote: > 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 > >
