SELECT, part 3
Query from the multiple tables"SELECT" can also pick out the data using multiple tables.I will introduce two of them.（１）Join multiple tablesThe SQL to join multiple tables and pick out the data is as follows.SELECT Item FROM TableName, TableName, ・・・WHERE Conditions for joining tablesAfter "FROM", describe the tables to be joined, separated by commas.After "WHERE", describe the conditions for associating items between tables.The conditions to join are mandatory.For example, the SQL for picking out the student's name and each teacher'sname from the "Grade" table and "HomeroomTeacher" table is as follows.SELECT Name, TeacherName FROM Grade, HomeroomTeacherWHERE Grade.Class = HomeroomTeacher.Cl
0
