i want to show all record of vesselName column which is mention v.vesselName
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 desc