How can I create a new table by using other two table's values.

ARUNN

• Sep 28th, 2006

 

You can try with the following:

CREATE TABLE table_name AS

(

SELECT column_name,column_name FROM tablename1

UNION ALL

SELECT column_name,column_name FROM tablename2

);

Shree

• Oct 11th, 2006

 

create table table_name as( select tab1.column1,tab1.column2,tab2.column3 from table_name tab1,table_name2 tab2 where tab1.colum1=tab2.column4);

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 9th, 2006

 

create table new_employees

as (select e.employee_id, e.first_name, e.last_name, d.department_name, d.department_id,
c.location_id, c.city from employees e, departments d, locations c
where e.department_id = d.department_id
and d.location_id = c.location_id
);