[RBASE-L] - Re: Table question

[Albert Berry]

CREATE VIEW vwSomeView AS SELECT Col1, Col2 FROM table1 +
UNION ALL SELECT Col1,Col2 FROM table2

or

CREATE TEMP TABLE tmpTable (Col1 INTEGER, Col2 TEXT (20) )
INSERT INTO tmpTable SELECT Col1, Col2 FROM Table1
INSERT INTO tmpTable SELECT Col1, Col2 FROM Table2

Albert

Dick Fey wrote:

I hate it when I know what I want but don't know how to accomplish it.
Tables 1 & 2  have multiple columns but  have 2 in common.

I want to make a new table, preferably a temp, that includes all the rows from both tables using only those 2 columns.

Tried a view, but that didn't seem to do it.

So many other options I have never used... looking for a simple suggestion.