三个表联合查询
SELECT cd6.id,cd6.name as namett,tf.* FROM ( table1 as tf INNER JOIN table2 as cd6 ON tf.id = cd6.id) INNER JOIN table3 as pg on tf.name='a'
三个表联合查询
SELECT cd6.id,cd6.name as namett,tf.* FROM ( table1 as tf INNER JOIN table2 as cd6 ON tf.id = cd6.id) INNER JOIN table3 as pg on tf.name='a'