SQL Server Join meaning

Question

When you write a join statement, and just use 'join' does that default to any join? Or is join also a type of join statement?

select * from a join b on a.c = b.c

score 4 · Accepted Answer · answered Sep 23 '14 at 20:07

4

join is the same as inner join.

answered Sep 23 '14 at 20:07

RedGreenCode

that's what the docs alluded to just wanted to make sure thanks! – finn green Sep 23 '14 at 20:22

1 Answers1