Sql Server2005 查询sql语句怎么写

2024-12-15 22:20:53

推荐回答（4个）

回答1：

Easy!

SELECT Order.orderNumber,
User.userName,
Pruduct.productName,
Shop.shopName
FROM Order, User, Cart, Pruduct, Shop
WHERE Order.userId = User.serId
AND Cart.orderId = Order.orderId
AND Cart.productId = Pruduct.productId
AND Shop.shopId = Order.shopId

这样效率会高一点
SELECT Order.orderNumber,
User.userName,
Pruduct.productName,
Shop.shopName
FROM Order INNER JOIN USER ON Order.userId = User.serId
INNER JOIN Cart, Pruduct ON Cart.orderId = Order.orderId AND Cart.productId = Pruduct.productId
INNER JOIN Shop ON Shop.shopId = Order.shopId

回答2：

先抢下沙发。马上解决

select order.orderid,user.username,pruduct.productname,(select shop.shopname from shop where shopid = order.orderid) from (order right join user

on order.userid = user.userid ) right join shop on order.shopid = shop.shopid;

给分吧

回答3：

select orderNumber as 订单编号,
(select userName from User) as 会员名称,
(select productName from Pruduct) as 商品名称,
(select shopName from Shop) as 供应商名称 from Order

回答4：

SELECT Order.orderNumber,
User.userName,
Pruduct.productName,
Shop.shopName
FROM User right join Order on Order.userId = User.serId right join Cart on Order.orderId=Cart.orderId right join Pruduct on Cart.productId=Product.productId right join Shop on Order.shopId=Shop.shopId

最新问答

我是高三文科生，想问一下思想政治都考查哪些情境？

数字电视的机顶盒上的USB接口是干什么用的

百度卫士怎么卸载根本找不到在哪

(n+1)的平方-n的平方等于多少？

中国式关系马伊琍大衣什么牌子

唱吧安卓版的安装文件在哪里？我是先用电脑下载好了再放到手机里的，找不到安装文件啊！

传问恐龙的灭绝是陨石撞地球造成的，那这块陨石有没有找到呢？

亲↖(^ω^)↗

双口镇附近是否有个富凯威洗浴

我两天没开奔驰E300车,第三天就打不开车门,这是为什么?