ORACLE SQL查询跨6个表使用inner返回重复数据

SELECT *
FROM table1
INNER JOIN table2 ON table1.column = table2.column
INNER JOIN table3 ON table2.column = table3.column
INNER JOIN table4 ON table3.column = table4.column
INNER JOIN table5 ON table4.column = table5.column
INNER JOIN table6 ON table5.column = table6.column;

SELECT column1, column2, COUNT(*)
FROM (
    SELECT table1.column1, table2.column2
    FROM table1
    INNER JOIN table2 ON table1.column = table2.column
    INNER JOIN table3 ON table2.column = table3.column
    INNER JOIN table4 ON table3.column = table4.column
    INNER JOIN table5 ON table4.column = table5.column
    INNER JOIN table6 ON table5.column = table6.column
)
GROUP BY column1, column2
HAVING COUNT(*) > 1;