set2sele.txt

来自「一个c语言开发的小型的dbms系统」· 文本 代码 · 共 7 行

SELECT * FROM Product,Sales WHERE Product.Productname=Sales.Productname; 
SELECT * FROM Time,Product,Sales WHERE Time.Month=Sales.Month AND Product.Productname=Sales.Productname; 
SELECT * FROM Location,Time,Product,Sales WHERE Location.Region=Sales.Region AND Time.Month=Sales.Month AND Product.Productname=Sales.Productname; 
SELECT Sales.Region,Sales.Productname,Product.Productline,Sales.Sale FROM Product,Sales WHERE Product.Productname=Sales.Productname; 
SELECT Sales.Region,Product.Productline,Sales.Sale FROM Production,Sales WHERE  Product.Productname=Sales.Productname AND Sales.Sale>997; 
SELECT Sales.Region,Product.Productname,Product.Productline,Sales.Sale FROM Production,Sales WHERE  (Product.Productname=Sales.Productname) AND (Sales.Sale>997 OR Sales.Productname='Productname1');