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 ...