我试图使用连接方法将多个表连接在一起,并选择一些变量,但它显示了n.DateOfShipping和n.ProductName,这两个在当前上下文中不存在。我得到了错误CS1061。Join(products, op => op.ProductId, pr => pr.Id, (op, pr) => new { pr.ProductName, op.DateOfShipping,Join(orders, op => op.OrderId, o => o.Id, (op, o) => new
当前查询: FORMAT(Tracking.[start],'dd-MM-yyy H:m:s') as [start], (SELECT Cast(SUM(Cast(stations.estimatedTime as decimal(18,2))/60 ) as decimal(18,2)[estimatedEnd],'dd-MM-yyyy') as estimatedEnd,
from Tracking le
请帮助我加入这两个选择:estimated from project_has_taskst1 left join users t2
SELECT IFNULL(sum(TIME_FORMAT(SEC_TO_TIME%i' )* t2.man_hour),0) as time_spent_cost FROM project_has_t