mysql count

July 17th, 2005, 02:30 PM

Bob Bedford

Guest

Posts: n/a

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

I've now those 2 queries:

select count(IDAnnounce)as countarticles from XXX where DateTimeSell is NULL
select count(IDAnnounce)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 ?

« previous question | next question »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using mysql count	Auddog	answers	3	November 20th, 2006 06:25 PM
Mysql count(condition)?	dottty	answers	14	March 3rd, 2006 04:15 AM
Problem with php/mysql count() function showing	auron	answers	3	February 23rd, 2006 07:45 PM
Mysql count(*) problem	skiserf	answers	0	July 20th, 2005 12:49 AM
Mysql count(*) problem	skiserf	answers	0	July 20th, 2005 12:49 AM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.