Reportviewer - Mysql - StoredProcedures

Question

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 tableshaving id as common field in tables.i'm new to stored procedures.Can u help me guys...... Guide me about stored procedures.

Pankaj Pandey · Answer

try it.. DELIMITER // CREATE PROCEDURE GetAllProducts() BEGIN SELECT T1.AT1.BT2.CT2.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 Sharma · Answer

I think you've posted the same question twice. Just answered I here PS: http://www.c-sharpcorner.com/Forums/Thread/212568/retrive-data-from-multible-tables-using-stored-procedures.aspx Thanks.