Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select dBUS.SDOMasterName, B.MinStepOrigin, B.MinStepDest, A.* from
- (subquery
- ) a
- INNER JOIN rpt.dimBUSolution dBUS ON dBUS.SolRunMasterID = a.[Run Master ID]
- INNER JOIN (select fBUS1.[Run Master ID], min(StepOriginID) MinStepOrigin, min(StepDestinationID) MinStepDest from rpt.FactBUSolution fBUS1 group by fBUS1.[Run Master ID]) B
- ON b.[Run Master ID] = a.[Run Master ID]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement