INNER JOIN (SELECt DISTINCT * FROM X) AliasON Alias.ID = Primary.ID
例如:
INNER JOIN (SELECt DISTINCT VMSUnitID, OrderId FROM tblOrderUnits) ouON o.id = ou.OrderId

INNER JOIN (SELECt DISTINCT * FROM X) AliasON Alias.ID = Primary.ID
例如:
INNER JOIN (SELECt DISTINCT VMSUnitID, OrderId FROM tblOrderUnits) ouON o.id = ou.OrderId