Usage of visual charts in MySQL and tips for joining multiple tables with INNER

Multi-table join query. If the relationship between tables is clear and the structure is simple, creating a view SQL code CREATE VIEW view_name AS SELECT t1.xxx, t2.xxx, t3.xxx FROM (table1 t1 inner join table2 t2 ON t1.fid = t2.fid) inner join table3 t3 ON t1.mid = t3.mid; three table associations are used here, tips for writing multi-table join inner join statements 1. first, write the simplest 2-table join INNER JOIN2. then use () to expand all data FROM after FROM to the end of the statement. JOIN at the end of the statement and JOIN with the inner join of the next table. Remember this principle. In the future, four tables will be associated, and five tables will not be difficult. Delete the VIEW SQL code DROP VIEW view_name author lj6684