joins in sql server
/*General Formula For Joins*/
SELECT Column_List
FROM Left_Table_Name
JOIN_TYPES Right_Table_Name
ON Join_Condition
/*INNER JOIN - Matching Rows + Non Matching Rows are Eliminated
LEFT JOIN - Matching Rows + Non Matching Rows from the Left table
RIGHT JOIN - Matching Rows + Non Matching Rows from the Right table
FULL JOIN - Matching Rows + Non Matching Rows from the Both tables
CROSS JOIN - Return cartesian product of the tables involved in the Join
SELF JOIN - Return each table row is combined with itself and with every other table row.
The SELF JOIN can be thought of as a JOIN of two copies of the same tables.*/
/*Cross Join*/
SELECT Column_List
FROM Left_Table_Name
CROSS JOIN Right_Table_Name
4.29
7
CREATE PROCEDURE SP_Purechase_Selecte
AS
SELECT
p.P_Id ,
p.p_name,
p.alias_name,
p.alias_code,
p.p_name_inlocal_language,
p.barcode,
p.buy_price,
p.sell_price_tak,
p.sell_price_ko,
p.qty,
typeQty.qty_type,
b.brand_name,
CA.cat_name ,
SN.sn_name ,
P.P_Description ,
p.Barwari_Krin
FROM tbl_Purchase p
INNER JOIN tbl_Qty_Type typeQty ON P.qty_type_id=typeQty.id
INNER JOIN tbl_Brand b ON p.brand_id=b.brand_id
INNER JOIN tbl_Catigory CA ON P.cat_id =CA.cat_id
INNER JOIN tbl_Sceintific_Name SN ON p.sn_id= SN.sn_id
INNER JOIN tbl_Product_Creation
GROUP BY P.P_Id,
CA.Cat_Name ,
P.P_Name ,
SN .Sn_Name ,
P.sellPrice ,
P.buyPrice ,
P.Barcode ,
P.Qty ,
P.P_Description,
p.Barwari_Krin
RETURN
Thank you!
7
0
3.89
10
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;
Thank you!
10
0
Are there any code examples left?
New code examples in category SQL
-
SQL 2022-03-28 00:45:25 how to get mysql on ubuntu
-
SQL 2022-03-27 22:00:47 install latest mysql on debian 9
-
SQL 2022-03-27 21:45:11 sql '=' cannot be applied to date varchar(10) athena
-
SQL 2022-03-27 21:20:41 sql is not null
-
SQL 2022-03-27 21:20:39 sql group by error
-
SQL 2022-03-27 20:35:10 replace null with 0 in sql
-
SQL 2022-03-27 19:30:32 concat column value of same user in mysql
-
SQL 2022-03-27 19:05:02 sql developer sql worksheet not showing
-
SQL 2022-03-27 18:45:07 kill a pid redshift