我有一个结合firstname和lastname的sql查询。但是,如果没有名字,则在第二个名字中有值,则组合的结果为空
select CompanyContact.FirstName + ' '
+ COALESCE(CompanyContact.LastName, '') AS Name
from bsDocument
LEFT JOIN Contact AS CompanyContact ON CompanyContact.ContactID = bsDocument.DocumentContactID
WHERE bsDocument.SellerID = 3632
AND bsDocument.Module = 'bsContract'
在下一列中,companycontact.firstname的值为空,companycontact.lastname的值为“dahal”,但结果显示为空。我该怎么解决?
最佳答案
使用concat()
select concat(CompanyContact.FirstName,' ',CompanyContact.LastName) AS Name
from bsDocument
LEFT JOIN Contact AS CompanyContact ON CompanyContact.ContactID = bsDocument.DocumentContactID
WHERE bsDocument.SellerID = 3632
AND bsDocument.Module = 'bsContract'