三列数据frm，一个表作为单列 [英] three column data frm one table as single column

问题描述

如何将一个表中的三列数据显示为单列?

How to display three columns data from one table as single column ?

Select ACODE as ID, PARTY_NAME as [NAME] from Tblmst_Party left outer join TblTrn_Purch_Enquiry a on Tblmst_Party.ACODE = a.PARTY_CODE1 left outer join TblTrn_Purch_Enquiry b on b.PARTY_CODE2 = tblmst_Party.ACODE left outer join TblTrn_Purch_Enquiry c on c.PARTY_CODE3 = tblmst_Party.ACODE  where c.ENQNO =16

这出了问题，请给我提出任何建议.

this is going wrong please suggest me any idea.

推荐答案

尝试一下..

Try this..

Select ACODE+PARTY_NAME as [ID and NAME] from Tblmst_Party left outer join TblTrn_Purch_Enquiry a on Tblmst_Party.ACODE = a.PARTY_CODE1 left outer join TblTrn_Purch_Enquiry b on b.PARTY_CODE2 = tblmst_Party.ACODE left outer join TblTrn_Purch_Enquiry c on c.PARTY_CODE3 = tblmst_Party.ACODE  where c.ENQNO =16

尝试通过以下方式进行查找.

try to find out in the following way.

select Cast(ID as varchar(20))+Cast(ENQNO  as varchar(20))+PARTY_NAME as Name from YourTableName

这篇关于三列数据frm，一个表作为单列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！