求教改写一条sql 检查一下数据,ordered_items_bak.[buying price]和ordered_items_bak.[public price] 允许空吗?没用Outer join 不应该有null 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 语句太晕。贴出表结构吧整理了一下语句花了3分钟。。先把语句给你,自己好好看下逻辑有没有错: select brand,linename,productref,description,ordered_items_bak.[buying price],ordered_items_bak.[public price] from orders,ordered_items_bak ,[product information],item_specification where orders.[order ref] = ordered_items_bak.[order ref] and [product information].[productref] = ordered_items_bak.[product reference] and ordered_items_bak.[product reference] = item_specification.[product reference] and ordered_items_bak.[order ref] = item_specification.[order ref] and item_specification.[order ref] = 'Sp0101123186' group by [orders].brand, [product information].linename, [product information].productref, [product information].description, [public price],[public price2], [public price3],[buying price], ordered_items_bak.[order ref] order by orders.brand,[product information].linename,[product information].productref 请问以下两句SQL命令如何合并为一句 [求救]ASP备份SQL数据库时备份不完整 请问这样的汇总怎么写? 怎么连不上数据库?大家帮我看下这是什么原因? 請問一個很淺的問題,在存儲過程中用臨時表會不會存在共用沖突? 判断Sql Server 表中的字段为计算字段 关于ID的问题 .hdr是什么扩展名? 请教一个分发复制中的问题,谢谢!!! 求英语文章,是关于数据库程序设计的 怎么将sql表导成dbf表(只能用SQL语句) 这个问题真的很难吗? 联接问题?
贴出表结构吧整理了一下语句花了3分钟。。先把语句给你,自己好好看下逻辑有没有错:
select brand,linename,productref,description,ordered_items_bak.[buying price],ordered_items_bak.[public price]
from orders,ordered_items_bak ,[product information],item_specification
where orders.[order ref] = ordered_items_bak.[order ref] and
[product information].[productref] = ordered_items_bak.[product reference] and
ordered_items_bak.[product reference] = item_specification.[product reference] and
ordered_items_bak.[order ref] = item_specification.[order ref] and
item_specification.[order ref] = 'Sp0101123186'
group by
[orders].brand,
[product information].linename,
[product information].productref,
[product information].description,
[public price],[public price2],
[public price3],[buying price],
ordered_items_bak.[order ref]
order by
orders.brand,[product information].linename,[product information].productref