sql right join or left join code example

Example 1: how to join tables in sql

JOINING 2 Tables in sql

SELECT X.Column_Name , Y.Column_Name2
FROM TABLES1_NAME X 
INNER JOIN TABLES2_NAME Y ON X.Primary_key = Y.Foreign_key;


--FOR EXAMPLE
--GET THE FIRST_NAME AND JOB_TITLE
--USE EMPLOYEES AND JOBS TABLE
--THE RELATIONSHIP IS JOB_ID

SELECT E.FIRST_NAME , J.JOB_TITLE
FROM EMPLOYEES E
INNER JOIN JOBS J ON J.JOB_ID = E.JOB_ID;

Example 2: Join In Sql Server

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