I have a page that displays a list of phone numbers in use on a table/database/server that I have readonly access to. I want to make a list of our entire phone number range, and diff this with the numbers in use table and output all open numbers. I feel like this would be pretty straight forward to do if I could add the table on the readonly database and insert the entire phone number range, unfortunately I cannot.
Is there a fairly simple way to do this? I have a mysql server running on another server that I have full access to as well.
NOTE: The readonly database is not MySql, I'm using ODBC to connect. The full access database is MySql