返回首页

如何显示单个列三列数据从一个表?

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

这是怎么回事错误请建议我任何想法。

回答

评论会员:游客 时间:2012/02/04
version_2.0:试试这个..codeprespanclass="code-keyword"Select/spanACODE+PARTY_NAMEspanclass="code-keyword"as/span[IDspanclass="code-keyword"and/spanNAME]spanclass="code-keyword"from/spanTblmst_Partyspanclass="code-keyword"left/spanspanclass="code-keyword"outer/spanspanclass="code-keyword"join/spanTblTrn_Purch_Enquiryaspanclass="code-keyword"on/spanTblmst_Party.ACODE=a.PARTY_CODE1spanclass="code-keyword"left/spanspanclass="code-keyword"outer/spanspanclass="code-keyword"join/spanTblTrn_Purch_Enquirybspanclass="code-keyword"on/spanb.PARTY_CODE2=tblmst_Party.ACODEspanclass="code-keyword"left/spanspanclass="code-keyword"outer/spanspanclass="code-keyword"join/spanTblTrn_Purch_Enquirycspanclass="code-keyword"on/spanc.PARTY_CODE3=tblmst_Party.ACODEspanclass="code-keyword"where/spanc.ENQNO=16/pre/code
Mahendra.p25
评论会员:游客 时间:2012/02/04
尝试找到下列方式codeprespanclass="code-keyword"select/spanCast(IDspanclass="code-keyword"as/spanspanclass="code-keyword"varchar/span(spanclass="code-digit"20/span))+Cast(ENQNOspanclass="code-keyword"as/spanspanclass="code-keyword"varchar/span(spanclass="code-digit"20/span))+PARTY_NAMEspanclass="code-keyword"as/spanNamespanclass="code-keyword"from/spanYourTableName/pre/code的