Combining fields into one name for output 1

[evergrean100]

Dont have access to Oracle at this time but want to make sure this is a correct statement?

select (firstname,lastname) as fullname, city from tableOne

 

[SantaMufasa]

Nope...

select firstname||' '||lastname as fullname, salary from tableOne;

FULLNAME                 SALARY
-------------------- ----------
Carmen Velasquez           2500
LaDoris Ngao               1450
Midori Nagayama            1400
Mark Quick-To-See          1450
Audry Ropeburn             1550

Let us know if this answers your questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[evergrean100]

thanks