jmginer Posted August 31, 2015 Share Posted August 31, 2015 Hello, how can I list client with 0 income? 0 Quote Link to comment Share on other sites More sharing options...
sentq Posted August 31, 2015 Share Posted August 31, 2015 where exactly do you need to use this query? 0 Quote Link to comment Share on other sites More sharing options...
sentq Posted August 31, 2015 Share Posted August 31, 2015 Use this query to list clients with no invoices at all SELECT * FROM `tblclients` WHERE `tblclients`.`id` NOT IN ( SELECT `userid` FROM `tblinvoices`) 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.