Use Intersect in sql server
1804
08-Mar-2016
We want to use Intersect in sql server.how will do this please help me.
Updated on 08-Mar-2016
Anonymous User
08-Mar-2016Intersect: The intersect statement is used to fetch the common records between the tables. Here we have two tables. Both tables have similar kinds of records.
CREATE TABLE ProductStock
(
ProductId INT PRIMARY KEY IDENTITY(1,1),
ProductName VARCHAR(100),
ManufacturedBy VARCHAR(100),
StockQty BIGINT,
LastUpdated date
)
Go
CREATE TABLE ProductOrder
(
OrderId INT PRIMARY KEY IDENTITY(1,1),
ProductId int,
ProductName VARCHAR(100),
ManufacturedBy VARCHAR(100),
OrderQty BIGINT,
OrderDate date
)
ProductStock :
ProductOrder:
INTERSECT QUERY :
SELECT ProductId,ProductName,ManufacturedBy FROM ProductStock
INTERSECT
SELECT ProductId,ProductName,ManufacturedBy FROM ProductOrder