34,837
社区成员




SELECT ta1.no,
ta1.name1,
ta2.name2,
ta3.name3,
ta4.name4
FROM table1 AS ta1
LEFT JOIN table2 ta2 ON ta1.no=ta2.no
LEFT JOIN table3 ta3 ON ta1.no=ta3.no
LEFT JOIN table4 ta4 ON ta1.no=ta4.no
SELECT ta1.no,
ta1.name1,
ta2.name2,
ta3.name3,
ta4.name4
FROM table1 AS ta1
INNER JOIN table2 ta2 ON ta1.no=ta2.no
INNER JOIN table3 ta3 ON ta1.no=ta3.no
INNER JOIN table4 ta4 ON ta1.no=ta4.no