nitaish Posted April 20, 2021 Share Posted April 20, 2021 (edited) Hello, Can someone provide me sql query to get the list of client having only domain orders. Thanks Edited April 20, 2021 by nitaish 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted April 20, 2021 Share Posted April 20, 2021 2 hours ago, nitaish said: Can someone provide me sql query to get the list of client having only domain orders. though I suspect in your case that last line would become... tblclients.id NOT IN ((SELECT userid from tblhosting)) so that you get a list of clients that are in tbldomains (they have a domain), but not in tblhosting... as per above thread, i'm not checking if the domains are active etc, but that can be added if necessary. 1 Quote Link to comment Share on other sites More sharing options...
nitaish Posted April 21, 2021 Author Share Posted April 21, 2021 thank you 😃 0 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.