SELECT
(SUM(L.total_linea) * I.porcentaje / 100) AS iva
FROM
linea_ventas L
JOIN
iva I ON L.id_iva = I.id_iva
GROUP BY
L.id_iva
我试图用LINQPad 5程序直接针对我的数据库编写查询,然后将其添加到我的代码中,但我在这里被阻止了:
from l in linea_ventas
join i in ivas on l.id_iva equals i.id_iva
group l by new { l.id_iva } into g
select new
{
iva = g.Sum(l => l.total_linea)
}
https://stackoverflow.com/questions/50319180
复制相似问题