Srijon

SELECT j.JobID,Ju.Remarks AS FirstCall,ju.UpdateTime FCTime,ju.Location FCLocation, ju1.Remarks AS Accept,
										ju1.UpdateTime AcceptTime,ju1.Location AcceptLocation,
										ju2.Remarks AS SecondCall,
										ju2.UpdateTime SecondCallTime,ju2.Location SecondCallLocation,
										ju3.Remarks AS Visit,
										ju3.UpdateTime VisitTime,ju3.Location VisitLocation,
										ju4.Remarks AS Wip,
										ju4.UpdateTime WipTime,ju4.Location WipLocation,
										ju5.Remarks AS JobDone,
										ju5.UpdateTime JobDone,ju5.Location JobDone
										  FROM JOB j
										    LEFT JOIN jobUpdate ju ON j.JobID=ju.JobID AND ju.RemarksID=27
										    LEFT JOIN jobUpdate ju1 ON j.JobID=ju1.JobID AND ju1.RemarksID=28
										    LEFT JOIN jobUpdate ju2 ON j.JobID=ju2.JobID AND ju2.RemarksID=29
										    LEFT JOIN jobUpdate ju3 ON j.JobID=ju3.JobID AND ju3.RemarksID=30
										    LEFT JOIN jobUpdate ju4 ON j.JobID=ju4.JobID AND ju4.RemarksID=31
										    LEFT JOIN jobUpdate ju5 ON j.JobID=ju5.JobID AND ju5.RemarksID=40
										WHERE j.jobID=13669