<%
strSql = ""
strSql = strSql & " SELECT "
strSql = strSql & " A.* "
strSql = strSql & " FROM "
strSql = strSql & GLOBAL_DB_TRADEPRODUCT & " A "
strSql = strSql & " LEFT OUTER JOIN "
strSql = strSql & GLOBAL_DB_TRADEPRODUCTBC & " B "
strSql = strSql & " ON "
strSql = strSql & " A.INT_BID = B.INT_BID "
strSql = strSql & " LEFT OUTER JOIN "
strSql = strSql & GLOBAL_DB_TRADEPRODUCTSC & " C "
strSql = strSql & " ON "
strSql = strSql & " A.INT_SID = C.INT_SID "
strSql = strSql & " WHERE "
strSql = strSql & " A.CHR_AUDITING = '1' "
strSql = strSql & " ORDER BY "
strSql = strSql & " B.INT_ORDER DESC "
strSql = strSql & " ,B.DAT_CREATETIME DESC "
strSql = strSql & " ,C.INT_ORDER DESC "
strSql = strSql & " ,C.DAT_CREATETIME DESC "
strSql = strSql & " ,A.INT_ORDER DESC "
strSql = strSql & " ,A.DAT_CREATETIME DESC "%>
我想把这个左连接换成其他方式 就是能支持asp的形式的 要如何去改? 我原来是asp+sql的 现在是asp+access的 这个不好用了 如何能让他好用那 -0-
strSql = ""
strSql = strSql & " SELECT "
strSql = strSql & " A.* "
strSql = strSql & " FROM "
strSql = strSql & GLOBAL_DB_TRADEPRODUCT & " A "
strSql = strSql & " LEFT OUTER JOIN "
strSql = strSql & GLOBAL_DB_TRADEPRODUCTBC & " B "
strSql = strSql & " ON "
strSql = strSql & " A.INT_BID = B.INT_BID "
strSql = strSql & " LEFT OUTER JOIN "
strSql = strSql & GLOBAL_DB_TRADEPRODUCTSC & " C "
strSql = strSql & " ON "
strSql = strSql & " A.INT_SID = C.INT_SID "
strSql = strSql & " WHERE "
strSql = strSql & " A.CHR_AUDITING = '1' "
strSql = strSql & " ORDER BY "
strSql = strSql & " B.INT_ORDER DESC "
strSql = strSql & " ,B.DAT_CREATETIME DESC "
strSql = strSql & " ,C.INT_ORDER DESC "
strSql = strSql & " ,C.DAT_CREATETIME DESC "
strSql = strSql & " ,A.INT_ORDER DESC "
strSql = strSql & " ,A.DAT_CREATETIME DESC "%>
我想把这个左连接换成其他方式 就是能支持asp的形式的 要如何去改? 我原来是asp+sql的 现在是asp+access的 这个不好用了 如何能让他好用那 -0-
解决方案 »
- 怎样对用select ...where id in (33,22,44)的结果排序?
- 没用过存储过程,下面的asp代码用存储过程怎么写?
- 求一SQL语句,在线等待高手解决,非常感谢~~~~~~~~~
- [老生常谈]触发器 外键那个更好
- 连接sql 2000 错误!bde error $220B 网上说是“Could not find language driver” 请问是什么回事?该怎么解决?
- SQL 报表服务 报表表格中数据咋么显示百分比,还有表格上下合并单元格
- 求一sql分页存储过程
- 急!特急!
- 问一个SQL数据表的问题
- 两表之间相同字段查询
- 求一个SQL句子.得出字段的个数.--新帖
- 求一段sql库存查询语句
strSql = ""
strSql = strSql & " SELECT "
strSql = strSql & " A.* "
strSql = strSql & " FROM (("
strSql = strSql & GLOBAL_DB_TRADEPRODUCT & " A "
strSql = strSql & " LEFT OUTER JOIN "
strSql = strSql & GLOBAL_DB_TRADEPRODUCTBC & " B "
strSql = strSql & " ON "
strSql = strSql & " A.INT_BID = B.INT_BID )"
strSql = strSql & " LEFT OUTER JOIN "
strSql = strSql & GLOBAL_DB_TRADEPRODUCTSC & " C "
strSql = strSql & " ON "
strSql = strSql & " A.INT_SID = C.INT_SID )"
strSql = strSql & " WHERE "
strSql = strSql & " A.CHR_AUDITING = '1' "
strSql = strSql & " ORDER BY "
strSql = strSql & " B.INT_ORDER DESC "
strSql = strSql & " ,B.DAT_CREATETIME DESC "
strSql = strSql & " ,C.INT_ORDER DESC "
strSql = strSql & " ,C.DAT_CREATETIME DESC "
strSql = strSql & " ,A.INT_ORDER DESC "
strSql = strSql & " ,A.DAT_CREATETIME DESC "%>