I want to move distinct City and Region in another table "Region".
can you help m with the select query?
it should be something like this but don't work:
Code: Select all
insert into Region(City,Region) values((select distinct City,Region from TEL))Moderator: General Moderators
Code: Select all
insert into Region(City,Region) values((select distinct City,Region from TEL))