在VB.net中加入两个表 [英] JOIN Two Table in VB.net

问题描述

大家好



如何加入Two Talble（表1是Fees_Transaction，表2是FeesMaster）有条件



我在这里使用Code但它不能正常工作

  Dim  strSQL5 作为 字符串 =   SELECT Fees_Transaction.Regno，Fees_Transaction.ST_Name，SUM（Fees_Transaction.Amount_Paid）as FTAmountPaid，SUM（FeesMaster.FeeAmount）As TotalFeeAmount FROM Fees_Transaction INNER JOIN FeesMaster ON Fees_Transaction.Regno = FeesMaster。 Regno和Fees_Transaction.FeeType = FeesMaster.FeeType WHERE Fees_Transaction.class ='& cboClass.Text&  'GROUP BY Fees_Transaction.Regno，Fees_Transaction.ST_Name 

以上代码ERROR是..



FeesMAster SUM计算问题..



请求HElp这个COde ..

解决方案

你应该分享一些不适合你的东西。



尝试：

  SELECT  
 Fees_Transaction.Regno，Fees_Transaction.ST_Name，SUM（Fees_Transaction.Amount_Paid） as  FTAmountPaid，SUM（FeesMaster.FeeAmount）正如 TotalFeeAmount 
  FROM  
 Fees_Transaction 
  INNER  < span class =code-keyword> JOIN  
 FeesMaster  ON  Fees_Transaction.Regno = FeesMaster.Regno 
  WHERE  
 Fees_Transaction.class = ' & cboClass.Text& ;'  AND  Fees_Transaction.FeeType = FeesMaster.FeeType 
  GROUP   BY  
 Fees_Transaction.Regno，Fees_Transaction.ST_Name 

请参阅： MSDN：使用内部联接 [ ^ ]

Hi all

How to join Two Talble(Table1 is Fees_Transaction AND Table 2 is FeesMaster) With Condition

Here I use Code But It''s Not Work Proper

Dim strSQL5 As String = "SELECT Fees_Transaction.Regno, Fees_Transaction.ST_Name, SUM(Fees_Transaction.Amount_Paid) as FTAmountPaid,SUM(FeesMaster.FeeAmount) As TotalFeeAmount FROM  Fees_Transaction INNER JOIN FeesMaster  ON Fees_Transaction.Regno=FeesMaster.Regno and  Fees_Transaction.FeeType=FeesMaster.FeeType WHERE Fees_Transaction.class='" & cboClass.Text & "'  GROUP BY Fees_Transaction.Regno, Fees_Transaction.ST_Name"

Above Code ERROR is..

FeesMAster SUM Calculate Problem..

Pleaes HElp This COde..

解决方案

You should have shared what was not working properly for you.

Try:

SELECT 
   Fees_Transaction.Regno, Fees_Transaction.ST_Name, SUM(Fees_Transaction.Amount_Paid) as FTAmountPaid,SUM(FeesMaster.FeeAmount) As TotalFeeAmount 
FROM  
   Fees_Transaction 
INNER JOIN 
   FeesMaster ON Fees_Transaction.Regno=FeesMaster.Regno
WHERE 
   Fees_Transaction.class='" & cboClass.Text & "'  AND Fees_Transaction.FeeType=FeesMaster.FeeType 
GROUP BY 
   Fees_Transaction.Regno, Fees_Transaction.ST_Name

Refer: MSDN: Using Inner Joins[^]

这篇关于在VB.net中加入两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！