自定义sql视图

自定义sql视图



请问怎么解决？

根据错误提示，你脚本丢失了一个分号，先检查下吧。

你的sql语句写错了。你把你的sql语句贴出来我帮你改下。

但是我在mysql执行能通过啊！！
sql如下：
var sql="SELECT a.ITEM_CreditGrade AS CreditGrade,a.ITEM_EnterpriseName AS EnterpriseName,a.ITEM_Contactperson AS Contactperson,a.ITEM_Phone AS Phone,b.ITEM_FullName AS FullName FROM tlk_s_enterpriseinfo a,tlk_e_information b WHERE b.ITEM_sel_info=’法定代表人信息' AND a.id=b.PARENT";
sql;

字段的别名需要加item_,这样你在列那里才能那样去取。
var sql="SELECT a.ITEM_CreditGrade AS item_CreditGrade,a.ITEM_EnterpriseName AS item_EnterpriseName,a.ITEM_Contactperson AS item_Contactperson,a.ITEM_Phone AS   item_Phone,b.ITEM_FullName AS item_FullName ,a.id as id ,a.domainid as domainid FROM tlk_s_enterpriseinfo a,tlk_e_information b WHERE b.ITEM_sel_info=’法定代表人信息' AND a.id=b.PARENT";
sql;

你用这个再试一下。
var sql="select * from (SELECT a.ITEM_CreditGrade AS item_CreditGrade,a.ITEM_EnterpriseName AS item_EnterpriseName,a.ITEM_Contactperson AS item_Contactperson,a.ITEM_Phone AS   item_Phone,b.ITEM_FullName AS item_FullName ,a.id as id ,a.domainid as domainid FROM tlk_s_enterpriseinfo a,tlk_e_information b WHERE b.ITEM_sel_info=’法定代表人信息' AND a.id=b.PARENT) s";
sql;