Hi, I've got two columns, municipality (string) and population (number). And I need to create virtual table which combines these two columns.
I was thinking to do it like this, but it doesn't seem to work. Any idea?
create view municipality_population as
select municipality &" "& population
from cities
select * from municipality_population