SELECT x.requestNumber,x.ContactFullName, x.webcastname,
when p.presenters = '0'
FROM [request].[dbo].[Postreceived] as p
Right outer JOIN [othercomputer].[request].[dbo].[Prereceived] as x
on p.requestNumber = x.requestNumber
I hope this makes sense, when
p.presenters is 0 or if it is null, then i want to return x.presenters, else just return p.presenters and call the colum presenters in the return.
It barfs on the as in this situation and if i take it out it barfs on the FROM.