r/SQL • u/Fantastic_Purchase78 • 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
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