Hi Friends, Please help me. Multiple table join with grouping in MySql with C# to get data in crystal report.
i have tried the following for your reference,
tableONE(BILLNO,FINYEAR,CUSTNAME,ADDRESS,CITY)
TABLEtwo(BILLNO,FINYEAR,VEHICLEDETAILS)
TABLEthree(BILLNO,FINYEAR,PROD_SLNO,PRODUCTDETAILS)
TABLEfour(BILLNO,FINYEAR,PROD_SLNO,PRODUCTDETAILS,ACCESS_SLNO,PRODACCESS,ACCESS_QTY)
TABLEfive(BILLNO,FINYEAR,PROD_SLNO,PRODUCTDETAILS,ACCESS_SLNO,PRODACCESS,DELIVERYFEEDBACK)
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_BILLDetails`(IN billNo DECIMAL,IN finYr INT)
BEGIN
SELECT DISTINCT * FROM tableone
left join tabletwo ttwo on tableone.BillNO = ttwo.BillNO
left join tablethree tthree on tableone.BillNO= tthree.BillNO
left join tablefour tfour on tableone.BillNO= tfour.BillNO
left join tablefive tfive on tableone.BillNO= tfive.BillNO
where tableone.BillNO = billNumber and BillNO .FINYEAR = finYr;
END $$
DELIMITER ;
Here i need the output is table-wise against BILLNO = FINYEAR