CODEWITHSUNDEEP
sql-serverstored-procedures
user2902180
user2902180

Reputation: 1041

SQL Server stored procedure using INNER JOIN

ALTER PROCEDURE [dbo].[SP_STORED_PROCEDURE]
AS
BEGIN  
  SELECT 
     CUSTOMER_NAME,
     CUSTOMER_PRODUCT_ID
  FROM CUSTOMER
  INNER JOIN PRODUCT ON PRODUCT_ID = CUSTOMER_PRODUCT_ID
END

I select data from product table. However, if CUSTOMER_PRODUCT_ID is null, I cannot select (see) null data.

How can I see all data?

or

Any help will be appreciated greatly.

Thanks.

Upvotes: 2

Views: 27831

Answers (1)

sahalMoidu
sahalMoidu

Reputation: 1152

ALTER PROCEDURE [dbo].[SP_STORED_PROCEDURE]
AS
BEGIN  
  SELECT 
     CUSTOMER_NAME,
     CUSTOMER_PRODUCT_ID
  FROM CUSTOMER
  Left Outer JOIN PRODUCT ON PRODUCT_ID = CUSTOMER_PRODUCT_ID
END

Using Left outer join returns the all the data from Customer table with the matching rows in the product table and also returns null when rows are unmatched

Upvotes: 2

Related Questions