mySQL多表连接

table1 inner join | {left|right} outer join table2 on condition

select column_list form t1 inner join t2 on condition1 inner join on t3 on condition2 where condition3

update  table1 inner join | {left|right} outer join table2 on condition set col1=,col2=  where condition

delete t1. t2. from t1 inner join t2 on condition where conditon