How to use SQL Joins in Stored Procedure explain with example?

Asked 14-Sep-2021
Viewed 360 times

0

How to use SQL Joins in Stored Procedure to explain with example?


1 Answer


0

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 : How to use SQL Joins in Stored Procedure explain with example?

Salesman table : How to use SQL Joins in Stored Procedure explain with example?

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 ,

        exec prcCustomerSales;

          How to use SQL Joins in Stored Procedure explain with example?

   You can also use 'left', 'right' and 'full outer' join in the place of 'inner join' in above example.