34,590
社区成员
发帖
与我相关
我的任务
分享
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