Hi, i just want to know what they are exactly and should they be avoided? thanks in advance.
showt2 (BOB member since 2009-05-11)
Join means you have two (or more) SQL passes due to context or other universe structures and all of the dimensions are shared. Synchronized means the same thing except the dimensions are not all shared.
Dave Rathbun 
(BOB member since 2002-06-06)
hey thanks for the reply, so basically you are going to get wrong results in either case, correct?
showt2 (BOB member since 2009-05-11)
No, that’s not what I said. 
I explained how they come about. Neither is “wrong” exactly. A join query is absolutely fine, and should not have any issues whatsoever. A synchronized query needs more careful examination, but it’s not automatically wrong.
Dave Rathbun (BOB member since 2002-06-06)