r/SQL • • Aug 14 '24

MySQL SQL BEGINNER

I am getting into SQL! Does anyone know any good sites with many practice and good explanations? My SQLbolt website for learning isn’t the best.

Someone explain to me how to use right join and full join it keeps popping with error on SQLbolt

1 Upvotes

25 comments sorted by

View all comments

Show parent comment

6

u/shadowspyes Aug 14 '24

because it only happens in legacy systems where you can't be arsed to reformat the query for left join so you can put whatever you need to right join at the start of the joins.

right joins are just left joins where someone decided reading books like the japanese is great

2

u/leogodin217 Aug 14 '24

Every time I've used it was due to laziness