Need help regarding sql query

[sideon]

---

to make to make two columns into one
kani lang nga format gamita --> (table1.colA + ', ' + table2.colB) as newColumn

SELECT (table1.colA + ', ' + table2.colB) as newColumn, table1.colC, table3.colD
FROM ....the rest of the sql statement

You're making 2 cols into 1 but the problem is making multiple rows or result set into one.

E,g,
Result
1
2
3

to

Result
1, 2, 3

[moz_k2]

ahh ok i get it

just refer here:
How do I concatenate strings from a column into a single row?

[DeathFox]

Thanks mga bros. I'll try it now