我很难想象如何将这个简单的 SQL 语句翻译成 (c#) linq to SQL:
SELECT table1.vat, SUM(table1.QTY * table2.FLG01 + table1.QTY * table2.FLG04)
FROM table1
inner join table2 on table2.key= table1.key
where '2010-02-01' <= table1.trndate and table1.trndate <= '2010-02-28'
Group by table1.vat
任何帮助都是受欢迎的