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

BrokenArrows

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

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

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

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.

conor.hogan.2

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

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

Source Page

Axe Rake

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