Loading

Retrive data from multible tables using Stored procedures

Kavi suja

Hi,
I have to generate report using reportviewer in .net using c#.I use mysql as DB.Now i've to write stored procedures for retriving data from three tables,having id as common field in tables.i'm new to stored procedures.Can u help me guys......
Guide me about stored procedures.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
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 ;

0
Sunny Sharma13y ago
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.
0