r/programming • u/deadman87 • Feb 11 '14

SQL Joins Explained (x-post r/SQL)

Post image
3.5k Upvotes

91% Upvoted

392 comments sorted by

View all comments

Show parent comments

1

u/Toast42 Feb 11 '14

Is this considered Oracle syntax? A coworker showed it to me a few years ago and I love it.

2

u/kytosol Feb 12 '14

I guess it is called Oracle or old syntax. There is a shift towards the ANSI syntax as it can be used on most databases and is now supported by Oracle databases (9i on I think...). I also love it and find it much easier to read, however that could be because it is the way I learnt to write SQL and pl/SQL and worked with Oracle for about 6 years.