kaveer
2/22/2017 - 4:24 PM

Convert column value

Convert column value

Select * 
From mdCvlibrary cv
Inner Join mdJobDetails jd On Cast(jd.Reference As varchar(200)) = Cast(cv.JobRef As varchar(200))
Inner Join mdCustomerAdvert ca On ca.AdvertId = jd.AdvertId
Where Title = 'Unity VR Developer'