query help
Posted: Thu Nov 03, 2005 7:03 am
I have in table "TEL" all telefones,names,adresses,City,Region ->many fields inserted in it
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:
in this the subquery returns many values and I can put in insert only at a time.
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))