Page 1 of 1

query help

Posted: Thu Nov 03, 2005 7:03 am
by sebs
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:

Code: Select all

insert into Region(City,Region) values((select distinct City,Region from TEL))
in this the subquery returns many values and I can put in insert only at a time.

Posted: Thu Nov 03, 2005 7:15 am
by feyd

Posted: Thu Nov 03, 2005 7:19 am
by sebs
simple!I should figgered that out by myself but I was blind and maybe sometimes outside help is great!Thanks..