Posted by Yas on 07/01/07 10:52

On 29 Jun, 23:38, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Yas (yas...@gmail.com) writes:
> > Now I can just do...
> > SELECT 'FirstName', firstName, 'SecondName', secondName,
> > 'Occupation' occupation
> > FROM Table1
> > Which would output the table I want with the values between '' showing
> > up in unnamed columns.... BUT is there a better way of doing this?
>
> That would indeed be the way to do it.

Thanks! :-)

[Back to original message]