Can we Combine two column in single column while create table?

Kelvin Wilson Apr 23, 2022 0 118

Forums › SQL › Can we Combine two column in single column while create table?

Staff asked 3 years ago

1 Vote Up Vote Down

Umang Ramani Marked As Accepted

Staff answered 3 years ago

yes, you can combine two-column while creating the table

use

CONCAT(c.FIRSTNAME, ',', c.LASTNAME) AS FIRSTNAME

this will work when you creating a temp table using insert into tamp table

Kelvin Wilson