如何在ASP.NET C#中组合具有多个条件的两个选择查询 [英] How to combain two select query with multiple conditions in asp.net c#

问题描述

如何在asp.net c#中组合具有多个条件的两个选择查询 我的查询
:

Query1:
..........

How to combain two select query with multiple conditions in asp.net c#
my query
:

Query1:
..........

SELECT
           dbo.MemberTransactionMaster.YearID,
           Month(dbo.MemberTransactionDetails.VoucherDate)as TMonth,
           SUM(dbo.MemberTransactionDetails.Credit)
FROM       dbo.MemberTransactionMaster INNER JOIN
dbo.MemberTransactionDetails ON dbo.MemberTransactionMaster.TransactionMasterID = dbo.MemberTransactionDetails.TransactionMasterID
WHERE dbo.MemberTransactionDetails.VoucherType='WC'
GROUP BY dbo.MemberTransactionMaster.YearID,Month(dbo.MemberTransactionDetails.VoucherDate)
Order by dbo.MemberTransactionMaster.YearID,Month(dbo.MemberTransactionDetails.VoucherDate)

Query2:
......

Query2:
...............

SELECT  SUM(dbo.MemberTransactionDetails.Debit)
FROM    dbo.MemberTransactionMaster INNER JOIN
dbo.MemberTransactionDetails ON dbo.MemberTransactionMaster.TransactionMasterID = dbo.MemberTransactionDetails.TransactionMasterID
WHERE dbo.MemberTransactionDetails.VoucherType='WW'

任何人都可以帮助我..........

Any one please help me..........

推荐答案

您可以像

you can use In clause like

VoucherType in (''WW'',''WC'')

这样使用In子句，而不是使用两个单独的命令.

instead of using two separate commands.

这篇关于如何在ASP.NET C#中组合具有多个条件的两个选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！