CREATE TABLE TableC SELECT tableA.field1,table1.field2,tableB.field1
FROM tableA,tableB WHERE joinCondition
That should do it, if I got the syntax correct. You do want to use the
create/select combo though.
On Thursday, September 26, 2002, at 12:59 AM, Jack wrote:
> Dear all
> i had two table
Hi!
It sounds like a simple UNION ALL thing, but I think I don'tunderstand well
what your problem is. Can you give an example?
Daniel
At 12:59 2002.09.26. +0800, you wrote:
>Dear all
>i had two tables, tableA & Table B.
>I want to create a permanent table call Table C which the first two field
