String StrSql= "select a.procuctid, a.productname,b.quantity_buy,c.quantity_sale from product a left outer join ("+ sql1 +") b on a.productid =b.productid left outer join (" + sql2 + ") c on a.productid = c.productid"
调试欢乐多
兄弟,你这做法还是语法错误,left outer join (" + sql2 + ") c 时出错!
各位帮帮忙呀!谢谢!
String StrSql= "select a.*,c.quantity_sale "
+"from "
+"( "
+"select a.procuctid, a.productname,b.quantity_buy from products a left join ("+ sql1 +") b on a.productid =b.productid "
+") a "
+"left join (" + sql2 + ") c on a.productid = c.productid"
*/