多个表连接使用C＃在mysql中进行分组，以获取Crystal报表中的数据 [英] Multiple table join with grouping in mysql with C# to get data in crystal report

问题描述

朋友们，请帮帮我。使用C＃在MySql中进行多个表连接以获取水晶报告中的数据。



i已尝试以下内容供您参考，



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

离开加入tablethree tthree on tableone.BillNO = tthree.BillNO

左加入tablefour tfour on tableone.BillNO = tfour.BillNO

left join tablefive tfive on tableone.BillNO = tfive.BillNO

其中tableone.BillNO = billNumber和BillNO .FINYEAR = finYr;

END $$



DELIMITER;



这里我需要输出是针对BILLNO = FINYEAR

解决方案

CREATE DEFINER =`root` @`localhost` PROCEDURE`sp_BILLDetails`（IN billNo DECIMAL，in finYr INT）

BEGIN

SELECT DISTINCT * FROM tableone

左边加入tabletwo ttwo on tableone.BillNO = ttwo.BillNO

左边加入tablethree tthree on tableone.BillNO = tthree.BillNO

离开加入tablefour tfour on tableone.BillNO = tfour.BillNO

左连接tablefive tfive on tableone.BillNO = tfive.BillNO

where tableone.BillNO = billNumber和BillNO .FINYEAR = finYr;

END

DELIMITER;



这里我需要输出是针对BILLNO = FINYEAR

查看这些

来自多个表的C＃Crystal Reports [ ^ ]

创建包含多个表格的Crystal报表ASP.NET [ ^ ]

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

解决方案

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

Check these
C# Crystal Reports from multiple tables[^]
Creating Crystal Report with Multiple Tables in ASP.NET[^]

这篇关于多个表连接使用C＃在mysql中进行分组，以获取Crystal报表中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！