
April 6th, 2004, 04:15 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 9
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
one problem solved, a new problem occurs
I now have the following sql query:
SELECT Dep.DeptName, Dep.Owes, COUNT(Car.OutTo) AS CarsOut, SUM(Car.Cost*((Today.Date-Car.OutOn)+1)) AS Liability, Dep.Owes+Liability AS Total
FROM Today, (Dep INNER JOIN Emp ON Dep.DeptName=Emp.DeptName) INNER JOIN Car ON Emp.Name=Car.OutTo
GROUP BY Dep.DeptName, Dep.Owes
HAVING Dep.DeptName <> 'It'
Wich gets exactly what I want, except if a Department has no cars out.. How can I retrive only the Dep.Name and Dep.Owes and forget about the rest if COUNT(Car.OutTo) equals null??? Do I have to divided it into two queries and test in the middle? Any suggestions?
|