我们有个视图是 SELECT t1.* FROM tlk_gzw_system_coverage t1 INNER JOIN tlk_gz...

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：
问：我们有个视图是  SELECT t1.* FROM tlk_gzw_system_coverage t1 INNER JOIN tlk_gzw_sys_bu_info t2  ON t1.ITEM_JG_BT_SBU_BU_CAPS = t2.item_bu_name ，这种怎么处理
答：这个sql联表查询，需要加fromid docid id applicationid  
      示例：
            (function() {
var doc = getCurrentDocument();
var rules_basis_name = doc.getItemValueAsString("rules_basis_name");
var rules_basis_no = doc.getItemValueAsString("rules_basis_no");
var department = doc.getItemValueAsString("department");
var sql = " SELECT TA.*,TB.ITEM_department,TB.ITEM_imple_date FROM TLK_test_item_rules_basis_detail TA LEFT JOIN (SELECT ITEM_rules_basis_no,ITEM_department,ITEM_imple_date FROM TLK_rules_basis) TB ON TA.ITEM_number=TB.ITEM_rules_basis_no WHERE PARENT IN (SELECT ID FROM TLK_test_item WHERE ITEM_number='" + test_item + "') ";
if (null != rules_basis_name && rules_basis_name.trim().length() > 0 ) {
  sql += " AND ITEM_name LIKE '%" + rules_basis_name.trim() + "%' ";
}
if (null != rules_basis_no && rules_basis_no.trim().length() > 0 ) {
  sql += " AND ITEM_number LIKE '%" + rules_basis_no.trim() + "%' ";
}
if (null != department && department.trim().length() > 0 ) {
  sql += " AND TB.ITEM_department LIKE '%" + department.trim() + "%' ";
}
return sql;
})();








1、问题描述最好图文并茂，如有视频/脚本可直接放出，这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决，请在该帖子下回复\"已解决可结帖\"