Hi Jacek0,
I might be being a cabbage but i have never seen :: used as a prefix to a join or anywhere else in sql actually. I had a quick search around and can't find anything about its usage.
Can you tell me what the :: does as a prefix to the built-in function fn_trace_gettable()?
cheers