I have to deal with a table which contains:
first_namesurnameemail1email2
... and I would like to create a view which combines both email columns thus:
first_namesurnameemail
It looks simple but I can't think of an obvious query.
gvim