mysql count

LinkBack

Thread Tools

Search this Thread

July 17th, 2005, 01:30 PM

Bob Bedford

Guest

Posts: n/a

mysql count

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 ?

Bookmarks

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

What is Bytes?

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 220,989 network members.

mysql count

Popular Articles

What is Bytes?