SQLite Join Tables

This tutorial shows how to create tables in SQLite, and then how to extract data from them using the SQL joins and filters. For more information check out http://www.squidoo.com/sqlitehammer.

This is part of my Squidoo Lens at http://www.squidoo.com/sqlitedatabasedesign#module46058772

For more information on SQLite, see

http://www.squidoo.com/sqlitehammer
http://www.squidoo.com/sqliteprogramming
http://www.squidoo.com/sqlitetutorial
http://www.squidoo.com/sqlitedatabasedesign

Category:

Science & Technology

Tags:

• SQLite Tutorial
• Tutorial SQL
• database programming

[xdr3amx007]

Sir, I love you.

[Jaynonymous1]

@xdr3amx007 So I guess you found the video useful?

[xdr3amx007]

@Jaynonymous1 Very much so. I was wracking my brain trying to figure out how to do the joins in SQLite.

[Jaynonymous1]

@xdr3amx007 Good that you figured it out. That is basically how you do it in MySQL, PostgreSQL, MS-SQL and others. You're on your way.

[briang]

Very helpful.  Thank you!

[tobuslieven]

Great tutorial. I've seen loads but yours is the first one that really explained how joins work, by first showing an example ***without*** a 'where' clause. Every other explanation I've seen just jumped in with the 'where' filter which really leaves the join mechanism itself obscured from understanding.

Thanks a lot! : )

[SanRaul]

This is very useful, Thank you!

[babapua]

Than you Jay ! Keep up the good work !

[booticus]

Jay, thanks a ton for this! I'm very stoked you posted it. I look forward to your other tutorials as well!

[noodpan]

Hey Jay,

Thanks for the tutorial mate. It's been a long time since I've had to use SQL and this video told me exactly what I wanted to know.