Retrive data from multible tables using Stored procedures

Sign in to answer this question.

• 

  Pankaj Pandey13y agoPosted Jun 4, 2013, 7:00 AM

  hello
  
  follow this
  
  

  DELIMITER //

   CREATE PROCEDURE GetAllProducts()

     BEGIN

     SELECT T1.A,T1.B,T2.C,T2.D.T3.E  FROM table1 T1 left join table2 T2 on T1.id=T2.Id

      left join table3 T3 on T1.id=T3.Id and T2.id=T3.id

     END //

  DELIMITER ;
  
  
  
• 

  Sunny Sharma13y agoPosted Jun 4, 2013, 6:46 AM

  i kavi suja,
  
  Here are the link for you to get started with MySQL Stored Procedure:
  
  http://net.tutsplus.com/tutorials/an-introduction-to-stored-procedures/
  
  http://www.mysqltutorial.org/getting-started-with-mysql-stored-procedures.aspx
  
  http://www.techflirt.com/mysql-stored-procedure-tutorial/
  
  These will help you to achieve the purpose.
  
  Write back for any clarification.
  
  Thanks.