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
Dear all
i had two tables, tableA & Table B.
I want to create a permanent table call Table C which the first two field
will be equal to Table A's first 2 field and last field will be equal to
Table B's first field.
can anyone pls tell me what query should i use?
it will be nice if you can provid
