Solved

MySql query question

Posted on 2006-07-18
4
237 Views
Last Modified: 2010-04-17
SELECT *, COUNT(*) AS Total FROM TableA
LEFT OUTER JOIN TableB ON TableA.EntryID = TableB.RelEntryID
GROUP BY TableA.EntryID

This query displays total how many entries match from TableB to TableA as "Total" and it works well but with one problem. If nothing matches, it gives 1 as "Total".

Any ideas?
0
Comment
Question by:blacklord
  • 2
4 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 250 total points
ID: 17128289
Select
    ta.EntryId,
    (select count(*) from TableB tb where tb.RelEntryID = ta.EntryID)
From
    TableA ta

Will give you 0 if there are no results
0
 

Author Comment

by:blacklord
ID: 17128360
it worked, thank you. But does this work only on  latest mysql version or work on older versions too. thanks.
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 17128374
It should work on v4.x but I have never used 3.x before so I do not know
0
 
LVL 3

Expert Comment

by:cdemir
ID: 17128961
it works v4.1+ because these versions supports subquery.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question