create table!

[raseena nm]

hi,
I wanna create a table by fetching columns from two other tables?
For eg:
table -1
name
age
table -2
part1
part2
I wanna create a 3rd table with the following fields
name
age
part1
part2
Any kind of help will be appreciable?
thanx.

[Mark Spritzler]

Actually Oracle makes it very simple. You can create a table from a query as in

CREATE TABLE myTable AS
SELECT tableA.fieldA, 
       tableB.fieldB
  FROM tableA, 
       tableB
 WHERE tableA.primaryKey = tableB.foreignKey

Hope that helps.
Mark