SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM (order_products inner JOIN
products ON order_products.p_id = products.id)
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE len(PDClass.id_code) = 4
错误提示:不支持连接表达式。
如果把right outer join换成inner join或者left join就没事,但不是我要的数据集,各位斑竹能不能帮我解决一下
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM (order_products inner JOIN
products ON order_products.p_id = products.id)
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE len(PDClass.id_code) = 4
错误提示:不支持连接表达式。
如果把right outer join换成inner join或者left join就没事,但不是我要的数据集,各位斑竹能不能帮我解决一下
解决方案 »
- 刚才有位高手,告诉我这条语句,就是不知道什么意思。
- 员工年终奖金津贴表 计算 sql server 高手请进
- 急!将远程的数据库导出到本地数据库时遇到“将对象从 Microsoft SQL Server复制到Microsoft SQL Server时失败”,
- 求一分组字符合并SQL语句
- SQLSERVER哥子些,小弟拜托了!
- 一个查询的问题,100相送~
- 特奇怪的现象,取出的值竟然不一样?~!
- 怎么使table组件连接上sql而不出现登录界面
- 如何实现左右连接
- 请推荐几本用VC++开发数据库应用程序的好书。
- 【求助】sql server 2000中, 单引号与双引号的区别
- 关于数据库日志操作问题
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM order_products inner JOIN
products ON order_products.p_id = products.id)
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE len(PDClass.id_code) = 4
FROM 子句语法错误。
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM order_products inner JOIN
products ON order_products.p_id = products.id
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE len(PDClass.id_code) = 4 sorry
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM order_products inner JOIN
products ON order_products.p_id = products.id --)
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE len(PDClass.id_code) = 4
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code' 中。
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM PDClass
left JOIN
products ON LEFT(products.class_code, 4) = PDClass.id_code
inner JOIN
order_products ON order_products.p_id = products.id
WHERE len(PDClass.id_code) = 4
SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM (order_products right outer JOIN
products ON order_products.p_id = products.id)
right outer JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code
WHERE len(PDClass.id_code) = 4
拿到了预期的结果,现在还差最后一个orders表需要连上去了,条件是CStr(orders.ID)=order_products.Order_id
哪位大哥帮忙看看
快搞定了
(SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code,
SUM(order2.totalprice)*PDClass.brokerage AS total1,0 as total2
FROM ((order2 RIGHT OUTER JOIN
products ON order2.pcode = products.pcode) RIGHT OUTER JOIN
PDClass ON LEFT(products.class_code, 4) = PDClass.id_code)
WHERE (len(PDClass.id_code) = 4)
GROUP BY PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code)
union
(
SELECT DISTINCT PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code,0 as total1, SUM(order_products.sub_total) AS total2 FROM (((order_products LEFT OUTER JOIN orders ON order_products.order_id = CSTR(orders.ID)) RIGHT OUTER JOIN products ON order_products.p_id = products.id) RIGHT OUTER JOIN PDClass ON LEFT(products.class_code, 4) = PDClass.id_code)WHERE (len(PDClass.id_code) = 4) GROUP BY PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code)
现在还需要把total1和total2求和输出到一个记录集去就完了,不知道怎么搞到一起去