hey guys. quick question.
got 5 tables. each has a field called "status." status is downloading, uploading or done.
whats the easiest way i can return a count of the AGGREGATE "downloading" records, "uploading" records and "done" records?
i know there has to be some way to do this without 5 queries, each saying count(*) from tableA where status = 'downloading' + count(*) from tableB.....
any help?
got 5 tables. each has a field called "status." status is downloading, uploading or done.
whats the easiest way i can return a count of the AGGREGATE "downloading" records, "uploading" records and "done" records?
i know there has to be some way to do this without 5 queries, each saying count(*) from tableA where status = 'downloading' + count(*) from tableB.....
any help?