兑现子查询关联

实现子查询关联

?WhereClip w=Customers._.CustomerID==Orders._.CustomerID;

var t = DBUtility.DB.From<Customers>().RightJoin<Orders>(DBUtility.DB.From<Orders>().Where(Orders._.CustomerID == "QUICK"), "Orders", w).LeftJoin<Employees>(Orders._.EmployeeID==Employees._.EmployeeID);