Hi friend i have small doubt in sql plz how to solve this one.
1)insert the data from one table to another table that time we write query like
select * into (new table name) from (existing table name)
like this way how to inssert multiple table data into one table .how we wirte query
acutal i have 2 table data like 1st table abc id,name,sal andother table xyz id,location
1,add,100 1, hyd
i comine this table to write query
select * from abc full join xyz on abc.id=xyz.id
this time all records retrive on both table.
this all data load into another new table. how we write query plz tell me
new table create while we write one table data into aonther table like this way to write multiple table data into new table
plz tell how to wirte query