Nilesh Sanyal wrote:I have learnt join, but I don't know how to apply those stuff in the stored procedure for doing the operation...
Forget about Stored Procedure for 2 minutes.
Try to find the solution by writing the query using Join to find the difference.
Once you are able to write the query properly, then use that query to create Store Procedure.
If you face any difficulties, post your query and we will try to help.