Example:
  Objective: In this example, we will use SQL joins to store procedures.Â
 CREATE PROCEDURE SP_TEXAS_R                                                                As                                                                                         Begin         Â
                SELECT e.FirstName, e.LastName , e.Emailaddress, P.Project                                                             FROM Tbl_Emp as e INNER JOIN Tbl_Project as p                                                             on e.ecode = p.ecode
 End
  Execute store procedure:
           EXEC  SP_TEXAS_R;
  Output: