multidomain Posted September 5, 2017 Share Posted September 5, 2017 Hi Team, i'm currently looking for a way to find list of domains that do not have hosting service. What we have tried is to join the table for hosting and domain and extract out the domains that do not have hosting. However, based on the test script it does not give correct answer. Can anyone suggest or give us a clue on how to achieve this? Thanks. 0 Quote Link to comment Share on other sites More sharing options...
multidomain Posted September 9, 2017 Author Share Posted September 9, 2017 any suggestion guys? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted September 9, 2017 Share Posted September 9, 2017 the SQL query below should give you a list of domains (and their status) that are in tbldomains, but not in tblhosting. SELECT domain,status FROM tbldomains WHERE domain NOT IN (SELECT domain FROM tblhosting) 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.