SQL INNER JOIN Syntax Tutorial PHP MySQL Database

Learn SQL INNER JOIN syntax for accessing data from two related tables in a single query according to clauses on the data. It will render a result set that has all selected columns from both tables.

[MundaneMuser]

Thanks. Your explanation helped me understand INNER JOIN a lot. I broke down the process like this...

"INNER JOIN is used to present information from related tables in one new table.

1. Select the tables and columns to be assessed
2. Join the tables with INNER JOIN
3. Specify matching columns from the tables that were joined in the previous step. Data in these columns will be combined in a new table
4. OPTIONAL - Specify any condition(s) that must be met for any of this data to be displayed in the new table"

I'm new to this and SQL in general, so I'm not sure if what I wrote is entirely correct. My simplified explanation, along with the INNER JOIN syntax, helps me remember the process better. For what it's worth, I hope my steps will help anyone having trouble learning INNER JOIN in SQL.

[ljay]

I had enough pictures before starting to understand how it works, haha, thank you!:D

[reeverbstudios]

Adam K! The Zen Master of Web Dev Fu!!!

[andreicastro]

Thank you hahahahaha you have new subscriber here:D

[peterm.souzajr.]

i needed this, as my social network gets more features i also need to find new solutions

[reeverbstudios]

Thank you so much for this...It is the very thing I have been waiting to see. But I have a question...Can I make a simple 4 row page with header, navi, content, footer....? And would the footer stick when the content gets overpopulated...moving the footer lower ?

[rnseby]

How important is it to close the mysqli? You're one of the few tutorials writers I see that closes it.

[humbletutorial]

Using data type datetime ( 2015-01-18 13:23:44 to  2015-01-18 15:45:21 ) how can we select only time and able to select between 13:23:44 to 15:45:21

[pater]

I did some SQL lessons, isnt INNER JOIN a method when you use LEFT JOIN twice, or a LEFT and RIGHT JOIN, to INNER JOIN information, where you have LEFT SIDE RIGHT SIDE then do a INNER JOIN to display information between them?

Btw i only had LEFT JOIN one to many and Many to many lessons.

[CarlRyds]

Adam what do you think about PDO and MVC for making web applications?

[pianoLee-sxdx]

Can someone help me out here? When would i use a inner join as opposed to a left join? I am trying to do a piano website where the user must be either a primer level, level 1, level 2 or level 3... should i use an inner join?

[felixsimard]

Hey Adam, I used the INNER JOIN sql syntax in one of my Web applications and I am getting duplicates... for example the db renders me three rows of the same two username I was fetching..I tried using the SELECT DISTINCT, but it didn't work,
Could you explain to me how I can fix this?
Thank you

[sharif]

very nice
but if i want for multi table

[MarcelRobitaille]

Why would you not just put all the data in one table if every user gets a row in each anyway?

[reeverbstudios]

Ooooh sorry...this is the wrong page...damn I thought I was in the flex model

[reeverbstudios]

You know how annoying the footer can be when it doesn't stick...