尝试这样，

Try like this,

select FirstName+' '+LastName as Name from TABLE1

对于下拉列表，如果您需要Id，请在查询中添加ID

For Dropdown,If you need Id,Add Id in Query

select ID,FirstName+' '+LastName as Name from TABLE1