Sql Server中Fetchichg数据的问题 [英] Trouble in Fetchichg Data in Sql Server
问题描述
Ive Four Tables
1 Sale(saleID int identity,AID) - 来自分配表的援助
2分配(AID int Identity,PurchaseID int) - PurchaseID从购买表
3购买(PurchaseID int,ProductID int) - 产品表中的ProductID
4产品(ProductID int Identity,ProductName)
我想从ProductTable Base获取ProductName Sale在售价ID
即
促销表
saleID - AID
- 1 ----- 2
分配表
AID --- PurChaseID
1 ----- 2
2 ---- -1
购买表
购买ID-ProductID
--- -1 ------- 2
---- 2 ------- 1
产品表
ProductID-ProductName
--- 1 ------- CellPhone
--- 2 -------笔记本电脑
我想结果为
SaleID - 产品名称
- -1 ----笔记本<无线电通信/>
我可以这样做使用表变量但是它会花费更多的执行时间
所以我想要一个小查询....我很安静困惑什么要做什么不做请帮助.......
逻辑我用于表变量是
首先我在Squence中从Sale Sale获得All AID
基于这些AID我将按顺序收集所有PurchaseID的分配表
基于这些PurchaseID的I从序列中收集购买表中的所有ProductID
并使用这些ProductID我在序列中得到他们的名字
之后我将所有SaleID和所有ProductName插入一个表中变量并选择它作为结果
您需要了解 JOIN [ ^ ]
或者使用Visual Studio中提供的工具来构建查询给你。
喜欢这个
SELECT sale.SaleID,Product.ProductName
FROM sale
INNER JOIN分配ON Allocation.AID = sale.AID
INNER JOIN购买ON Allocation.PurChaseID = Purchase.PurchaseID
INNER JOIN产品ON Purchase.ProductID = Product.ProductID
Ive Four Tables
1 Sale(saleID int Identity,AID)--Aid From Allocation Table
2 Allocation(AID int Identity, PurchaseID int)--PurchaseID From Purchase Table
3 Purchase(PurchaseID int,ProductID int)--ProductID From Product Table
4 Prodcut(ProductID int Identity,ProductName)
I want To Get ProductName From ProductTable Base On SaleID
i.e.
sale Table
saleID--AID
--1-----2
Allocation Table
AID---PurChaseID
1-----2
2-----1
Purchase Table
PurchaseID-ProductID
----1-------2
----2-------1
Product Table
ProductID-ProductName
---1-------CellPhone
---2-------Laptop
I want Result as
SaleID--ProductName
---1----Laptop
I can do This Using Table Variable but It will Take more Execution Time
So I Want a Small query....Im Quiet Confused What to do and What to not Please Help.......
Logic I used For Table Variable is
First I took All AID From Sale Master in Squence
Based On these AID's I'm Collecting All PurchaseID's From Allocation Table in Sequence
Based On These PurchaseID's I'm Collecting All ProductID's From Purchase Table in Squence
and Using these ProductID's I get their Names in Squence
After that I'm Inserting All SaleID's and All ProductName in One Table Variable and Selecting it as a Result
You need to learn about JOIN [^]
Or use the tools provided in Visual Studio to build queries for you.
Like this
SELECT sale.SaleID, Product.ProductName FROM sale INNER JOIN Allocation ON Allocation.AID = sale.AID INNER JOIN Purchase ON Allocation.PurChaseID = Purchase.PurchaseID INNER JOIN Product ON Purchase.ProductID = Product.ProductID
这篇关于Sql Server中Fetchichg数据的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!