Find a Php,mysql association query statement, how to resolve

Finding a php,mysql associated query statement
Article table: ID, ClassID, Title
Class table: ClassID, ClassName
Require the query article table to be removed from the class table based on the value of ClassID classname
Like the Select (select classname from Table_b where Classid=table_a.classid) in MSSQL, * from table_a
Do not know how the MySQL query, please help!

------Solution--------------------

SQL Code

Selete Article.classid,class.classid,class.classname as Aclassname from Rticle,class where article.classid= Class.classid
------Solution--------------------
SQL Code
Select Article.id class.classname article.title from article inner join Class on (ARTICLE.CLASSID=CLASS.CLASSID)
