SQL JOINs in Stored Procedure :
In SQL the JOIN command is used to fetch or retrieve the records form more than two given related table by a specific value or column. As you can say that the SQL join command is used to combine two or more database table based on common column name to retrieve records from that tables.
As you know how to process the SQL join command in the database tables. You can create a Stored Procedure and store all that records in it which are retrieved from two or more related tables by using join commands. Following is an example of storing records in Stored Procedure which are retrieved from two different database table as 'Customer' and 'Salesman' .
Customer table :
Salesman table :
When you need to store records in a stored procedure then you have need to create a new Stored Procedure then you can store records in it.
Following is the SQL join command is used to store data in Stored Procedure-
create procedure prcCustomerSales AS
select cust.customer_id,cust.cust_name, sale.salesman_id,sale.name,sale.city
from Customer AS cust inner join Salesman As sale on cust.salesman_id=sale.salesman_id;
To show the created Stored Procedure the following SQL command is used ,
You can also use 'left', 'right' and 'full outer' join in the place of 'inner join' in above example.