How do I create a new table with another column from existing 2 tables where values be filled according to certain conditions?
The syntax for creating a new table with another column
1)create table by copy all column from antother table
syntax:-
create Table New_tableName
as
select column1,column2,column3 from existing table.
2)create table by copy selected column from another table
syntax:-
create Table New_tableName as
select column1,column2,column3 from oldtable1,oldtable2,oldtable3
example:-
create Table Employee as
select Company.CID,,Company.Address,Department.Depat from Company,Department