Posted on: 2/6/2014 7:50:26 AM | Views : 555

i have this select statement which results arent coming like the way i want
SELECT b.DepartedCountry, COUNT(c.VesselCode) AS VesselCode FROM Vessel_Departure AS a INNER JOIN Vessel_DepClearence AS b ON a.DepartureId = b.DepartureId AND a.DepartYear = b.DepartYear AND a.DepartCuo = b.DepartCuo INNER JOIN Vessel_VesselInfo AS c ON a.VeselRegNo = c.VeselRegNo GROUP BY b.DepartedCountry, c.VesselCode it gives me this result
DepartedCountry     VesselCode
JAPAN                        1
CHINA                         1
RUSSIA            ...

Go to the complete details ...