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
Bookmarks