Im looking for a good tutorial on how SQL joins work.

BrokenArrows · 11-05-2012 03:23PM #1

I want to fully understand how all the joins work in SQL.
I get how they work when im dealing with two tables but when i get into 2+ i get confused and i think i need to go back to basics.

Any suggestions or links to tutorials?

Ballyv24 · 11-05-2012 03:49PM

I find this useful http://www.w3schools.com/sql/sql_join.asp

That page plus the next 4 give a really good explanations and examples

Cork24 · 11-05-2012 04:07PM

http://www.amazon.com/Database-Systems-Practical-Implementation-Management/dp/0321523067/ref=sr_1_1?s=books&ie=UTF8&qid=1336748831&sr=1-1

BrokenArrows · 11-05-2012 04:41PM

Cork24 wrote: »

http://www.amazon.com/Database-Systems-Practical-Implementation-Management/dp/0321523067/ref=sr_1_1?s=books&ie=UTF8&qid=1336748831&sr=1-1

$108
I think ill pass. lol.

11-05-2012 05:09PM

BrokenArrows wrote: »

$108
I think ill pass. lol.

You could probably get it in a library or elsewhere for cheaper/free. It is in Blanchardstown library for example but not for loan.

CreepingDeath · 13-05-2012 05:32PM

This SQL venn diagram page is very good at showing the various SQL join results.

Source Page

Axe Rake · 13-05-2012 06:09PM

I suggest you download MySQL Server and run it off your own computer or your local network server if you have one.

Link here: http://dev.mysql.com/downloads/mysql/

Then install this small and very useful MySQL client named HeidiSQL.

Link here: http://www.heidisql.com/download.php

Once installed, setup the database and create 2+ tables and fill it with some random data.

Now, armed with the info given by the other posters and the diagram kindly provided by CreepingDeath, practice some SQL join queries and try to analyse and understand the returned results.

Best of luck

Im looking for a good tutorial on how SQL joins work.

Comments