How to sort and compare data from a SQL and an Access database

I have a datagridview in my C#.net application that pulls data from a SQL database (id,name,details). I have functionality in my program that flags a record when I click on a row. When a row is flagged it stores the ID of the flagged row in my Access database. I need to be able to sort the grid listing those IDs that are stored in my access database by clicking on a button . The problem is I am working with data from a sql and access database. I need a mechanism that compares the ID in the access database with the data pulled from the sql database and list the records of the IDs that are stored in the Access database first. So the data is coming from the sql server but the IDs that are in the database are listed first