santosh86 says:
Select v.VesselName,r.CreatedDate,r.DoneOnDate from Vessel v inner join ResilienceEmployee r on v.VesselId=r.VesselId
INNER JOIN ModuleMaster m On m.ModuleId = r.ModuleId
INNER JOIN sessionMaster s On s.ModuleId = r.ModuleId
where v.companyMasterid=1 and r.Status in('Y','N') and r.category= 'F' order by r.CreatedDate,r.DoneOnDate
replace above with below
SELECT v.VesselName,r.CreatedDate,r.DoneOnDate
FROM Vessel v
LEFT JOIN ResilienceEmployee r ON v.VesselId=r.VesselId
LEFT JOIN ModuleMaster m ON m.ModuleId = r.ModuleId
LEFT JOIN sessionMaster s ON s.ModuleId = r.ModuleId
WHERE v.companyMasterid = 1
AND r.Status IN('Y','N')
AND r.category= 'F'
ORDER BY r.CreatedDate,r.DoneOnDate
Even if you fire the query with left join then also it is possible that you wont get the specific results because you are using the WHERE condition in your query where it will the return the data as per condition.
You can read below for detail on join.
INNER JOIN: Returns all rows when there is at least one match in BOTH tables
LEFT JOIN: Return all rows from the left table, and the matched rows from the right table
RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table
FULL JOIN: Return all rows when there is a match in ONE of the tables