Code: Select all
$query = "SELECT count(a)+count(b) AS total FROM tableA, tableB WHERE tableA.id = '$id' AND tableB.id = tableA.id";It seems that both tables need to have something w/ that ID for it to work, is there a way to do that count without using two queries?
Like, if there is something to count in one table, but not in the other?
Please help, Thanks