Hi All

Thank you for your guidance, after some more digging and some more help the modified code that worked was:

FROM person p

JOIN Context AS ctx

ON ctx.subject =...

I appreciate all your help guys, simply I just don't get it... I have got a 2 query windows open side by side comparing the statements and I believe I...

Thanks Gail, yes sorry I had it spelt right in the query, but when I added

FROM person p, busidentity bi

It doesn't seem to allow me to add two...

Sorry, Error is "The multi-part identifier "busidentity.descritpion2" could not be bound."

Thanks for the help Gail and Ten Centuries. Ten Centuries, that snippet didn't work I still get a result with no records.

I did try and break the code down, I...

Hi Ian

Thanks for that, I was what I thought I was doing :-).

I saw that =* is an OLD SQL statement no longer supported, when I tried to use just...

Thank you all for looking a the post, got some help from a user and re-wrtten the code.

In case anyone was interested, here is the fixed version

FROM person p

JOIN accessGroup...

Hi Tom

To be honest, probably not 🙂

I come from a sysadmin back ground, not SQL. I know enough to get me through basic troublehshooting, but I'm having issues rewriting this...