如何以特定格式显示查询结果-Howtodisplayqueryresultinaparticularformat

I have two columns named FirstName and LastName. I want to query these from the table and display them in the format "FirstName LastName" (Note there is a space between FirstName and LastName) under the same column.

我有两列名为FirstName和LastName。我想从表中查询这些并在同一列下以“FirstName LastName”格式显示它们(注意FirstName和LastName之间有一个空格)。

Edit 1

I tried this

我试过这个

and the result comes like this

结果是这样的

Why am I getting 0's ?

我为什么得到0?

3 个解决方案