View Single Post
  #2 (permalink)  
Old April 15th, 2006, 04:30 AM
vinod_yadav1919 vinod_yadav1919 is offline
Friend of Wrox
Join Date: Oct 2004
Location: delhi, delhi, India.
Posts: 553
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to vinod_yadav1919 Send a message via Yahoo to vinod_yadav1919

Hii jfergy!!
try this

 SELECT WaterBodies.WaterBodyName, COUNT(Listings.Status) AS totalActive
FROM WaterBodies
INNER JOIN WaterbodyJoin
          ON WaterBodies.WaterBodyID= WaterbodyJoin.WaterBodyID
 INNER JOIN Listings
          ON Listings.ListingId = WaterbodyJoin.ListingId
GROUP BY WaterBodies.WaterBodyName, Listings.Status
HAVING (Listings.Status = 1)

hope this will help you

Cheers :)

Reply With Quote