mysql count

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Bob Bedford

    mysql count

    I've no access to mysql NG, so I ask here.

    I've now those 2 queries:

    select count(IDAnnounc e)as countarticles from XXX where DateTimeSell is NULL
    select count(IDAnnounc e)as countarticles from YYY where DateTimeSell is NULL

    Now, I've to have an unique counter. I've tried a query, but I get more than
    7800 results as I should get around 360

    Now, how can I get the total amount of IDAnnounces from the differents
    tables ???? with only 1 query ?


Working...