SQLTeam.com | Weblogs | Forums

What is the difference between ON (C1=C2 AND C3=C4) and ON (C1=C2 OR C3=C4)?

Hello

What is the difference between ON (C1=C2 AND C3=C4) and ON (C1=C2 OR C3=C4) ?

Thanks!

ON (C1=C2      AND        C3=C4) 
ON (C1=C2       OR        C3=C4) 

see the difference ... AND does something else OR does something else
1 Like

You are a programmer and you don't understand the difference between and and or? Seriously?

'and' means both items need to true before action is taken

'or' means that either item can true for action to be taken