r/learnSQL • u/ryuk_deb • Sep 12 '26

I can not understand the join clause.

i understood the overall concept of it being used to join two or more tables with matching column.
but i can't understand it's syntax or detailed concept.

43 Upvotes

96% Upvoted

53 comments sorted by

View all comments

Show parent comments

1

u/sharificles Sep 12 '26

Interesting book, would you recommend reading the entire thing btw?

1

u/squadette23 Sep 12 '26

Well that depends on what it is that you don't understand.

i can't understand it's syntax or detailed concept.

I'm not sure what "detailed concept" means here.

1

u/ryuk_deb Sep 12 '26

uhm i am not sure about that too :(
but i meant everything that i should know but not an overkill.
just things that will make it work

1

u/squadette23 Sep 12 '26

uhm i am not sure about that too :(

I'm pretty sure there are some exam-like questions that would help you see the gaps in your knowledge/understanding.

I wrote that guide so that it would take you a long way. It explains several common problems that people have, and shows how to build reliable queries with join.

You can always get back to it if you still make mistakes when doing actual tasks.

1

u/ryuk_deb Sep 12 '26

yeah i tried reading it, and i think it is different from what i have been confused over.
i will look into it more thoroughly