From a datas in
Join in cab on b a.S erviceOrderId equals b.S erviceOrderId
Join in sod on c a.S erviceOrderId equals c.I d
The join d in sum on a.C reateUserId equals d.I d
Select new {a, b, c, d};


The need to find out a data, but out of b, c, d three some data in the table, but a and b, a and c is a one-to-many relationship, so will find out a lot of repetitive, solving wouldn't let him to repeat