[SQL] Populating using Select

[Ezequias Rodrigues da Rocha]

Hi list,

I need to populate a neigborhood table base on a select of another table that already have a good amount of neigborhood saved.

Could someone tell me how it is possible ?

I was trying to make something like this:

Insert into base.neigborhood values (nextval(), Select distinct name from base.clients).

I didn't try it but I suppose it will not work.


Regards ...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/