INNER JOIN
Inner join responsible to returns rows which
have a match in both tables.
See following example:-
CREATE TABLE #ORDER
(
orderId INT IDENTITY(1,1),
fName VARCHAR(400),
lName VARCHAR(400),
ShipAddress VARCHAR(1000),
dtCreate DATETIME
)
CREATE TABLE #ORDER_DETAILS
(
orderDetailsId INT IDENTITY(1,1),
productName VARCHAR(400),
pPrice DECIMAL(18,2),
iQTY INT,
orderId INT,
dtCreate DATETIME
)
INSERT INTO #ORDER(fName,lName,ShipAddress,dtCreate)
SELECT 'Dilip','SINGH','New Delhi',GETDATE()
UNION ALL
SELECT 'Nirmit','katiyar','Mumbai',GETDATE()
UNION ALL
SELECT 'Raj','Dongra','Jharkhand',GETDATE()
UNION ALL
SELECT 'Salim','safi','Muradnagar UP',GETDATE()
INSERT INTO #ORDER_DETAILS(productName,pPrice,iQTY,orderId,dtCreate)
SELECT 'Product 1', 180,3,1,GETDATE()
UNION ALL
SELECT 'Product 2', 120,1,2,GETDATE()
UNION ALL
SELECT 'Product 3', 100,1,3,GETDATE()
UNION ALL
SELECT 'Product 4', 40,2,4,GETDATE()
UNION ALL
SELECT 'Product 5', 90,1,5,GETDATE()
--INNER JOIN
SELECT ORD.fName,ORD.lName,ORD.ShipAddress,ORDTL.productName, ORDTL.iQTY,ORDTL.pPrice,ORD.dtCreate FROM #ORDER
AS ORD
INNER JOIN #ORDER_DETAILS AS
ORDTL ON
ORDTL.orderId=ORD.orderId
DROP TABLE #ORDER
DROP TABLE #ORDER_DETAILS
Result;
Here you can see 5 rows from #ORDER_DETAILS table is not showing
Comments
Post a Comment