SELECT A.column1, A.column2, A.column3, A.column4, B.column1, B.column2, C.column1, D.column1 FROM table1 AS A INNER JOIN table2 AS B ON A.id = B.table1_id INNER JOIN table3 AS C ON A.id = C.table1_id INNER JOIN table4 AS D ON B.id = D.table2_id INNER JOIN table5 AS E ON C.id = E.table3_id INNER JOIN table6 AS F ON D.id = F.table4_id INNER JOIN table7 AS G ON E.id = G.table5_id INNER JOIN table8 AS H ON F.id = H.table6_id;

写一段八个表联查的sql

原文地址: https://www.cveoy.top/t/topic/Fvj 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录