Query Help ..

query = "SELECT count(a)+count(b) AS total FROM tableA, tableB WHERE tableA.id = '$id' AND tableB.id = tableA.id";

The total always comes up to be 0 - even though ONE of the tables has something to count

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

query = "SELECT count(tableA.a)+count(tableB.b) AS total FROM tableA, tableB WHERE tableA.id = '$id' AND tableB.id = tableA.id";

you just need to specifiy what is coming from what table

hth

bastien

No, still doesnt work, still get 0.

The problem happens when there is no corresponding ID in tableB, it returns 0, b/c it cant find the ID in both tables.

of course the query will fail when there is no corresponding ID in tableB...there is nothing you can do about that.

What you could do is to run a check to see if there is a result, if not then run another query...

hth

bastien

the reason for me asking this question is so that I wouldn't have to run 2 queries.