MySQL Syntax I'm confused about

[scrubbicus]

"SELECT * FROM $t_countries c INNER JOIN $t_cities ct ON c.countryid = ct.countryid AND ct.enabled = '1' WHERE c.enabled = '1' GROUP BY c.countryid $sort1";

 

So I'm configuring another application to suite my needs and I came across this crazy statement. I'm really only familiar with the basics (INSERT, DELETE, UPDATE, LIMIT, ORDER BY, AND), anyone have a good website that would explain these for me? They certainly look like they could help a lot.

[RichardRotterdam]

If this is your query

"SELECT * FROM $t_countries c INNER JOIN $t_cities ct ON c.countryid = ct.countryid AND ct.enabled = '1' WHERE c.enabled = '1' GROUP BY c.countryid $sort1";

And this is what you know

I'm really only familiar with the basics (INSERT, DELETE, UPDATE, LIMIT, ORDER BY, AND)

 

that leaves you with joines. I suggest you look up how to work with joins

this site has a tutorial about that here http://www.phpfreaks.com/tutorial/data-joins-unions