我知道,我改成了这样,不止到是否正确
sql = "SELECT a.*,b.sName AS ActorName,b.sCode AS ActorCode,d.sShortName AS CompanyName,e.sSymbol"
+"FROM RESOURCEMANAGERROLE c ,COMPANYACTOR a LEFT JOIN ACTOR b ON a.nActorID = b.ID"
+"LEFT JOIN COMPANY d ON a.nCompanyID = d.ID"
+"LEFT JOIN CURRENCY e ON b.nCurrencyID = e.ID"
+"WHERE a.ID = c.nCompanyActorID AND c.nResourceMngID = ?"
+"ORDER BY d.sShortName,b.sName";
sql = "SELECT a.*,b.sName AS ActorName,b.sCode AS ActorCode,d.sShortName AS CompanyName,e.sSymbol"
+"FROM RESOURCEMANAGERROLE c ,COMPANYACTOR a LEFT JOIN ACTOR b ON a.nActorID = b.ID"
+"LEFT JOIN COMPANY d ON a.nCompanyID = d.ID"
+"LEFT JOIN CURRENCY e ON b.nCurrencyID = e.ID"
+"WHERE a.ID = c.nCompanyActorID AND c.nResourceMngID = ?"
+"ORDER BY d.sShortName,b.sName";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货