Middlesex defeated Yorkshire by seven wickets in the Metro Bank One-Day Cup at Radlett, chasing 227 with Joe Cracknell hitting 97 and Ryan Higgins 62*.