Using a SQL Statement to filter a list on sharepoint

Jun 5, 2014 at 12:43 AM
I want to filter a list on SharePoint based off a Select statement from a SQL. Example Select ID from dbo.data

I want to filter the SharePoint source list to just the ID's in the SQL table above. I am at a total loss how to do this. I have a good connection and can bring in all the content of a list right now so all the connections and flow into SLQ is fine. Now just want to apply a SELECT Filter.
Any help would be greatly appreciated.