设主表=t1,外键表=t2 select t2.*,a.name as name1,b.name as name2,c.name as name3 from t2 left join t1 as a on a.id=t2.designno left join t1 as b on b.id=t2.constructno left join t1 as c on c.id=t2.qualityno
设主表=t1,外键表=t2 select t2.*,a.name as name1,b.name as name2,c.name as name3 from t2 left join t1 as a on a.id=t2.designno left join t1 as b on b.id=t2.constructno left join t1 as c on c.id=t2.qualityno
设主表=t1,外键表=t2 select t2.*,a.name as name1,b.name as name2,c.name as name3 from t2 left join t1 as a on a.id=t2.designno left join t1 as b on b.id=t2.constructno left join t1 as c on c.id=t2.qualityno
SELECT a.*, b.Name AS designnoname, c.Name AS constructnoname d.name as qualitynoname FROM 外键表 a INNER JOIN 主表 b ON a.designno = b.ID INNER JOIN 主表 c ON a.constructno = c.ID INNER JOIN 主表 d ON a.qualityno = d.ID忘了有三个字段
select t2.*,a.name as name1,b.name as name2,c.name as name3 from t2
left join t1 as a on a.id=t2.designno
left join t1 as b on b.id=t2.constructno
left join t1 as c on c.id=t2.qualityno
select t2.*,a.name as name1,b.name as name2,c.name as name3 from t2
left join t1 as a on a.id=t2.designno
left join t1 as b on b.id=t2.constructno
left join t1 as c on c.id=t2.qualityno
select t2.*,a.name as name1,b.name as name2,c.name as name3 from t2
left join t1 as a on a.id=t2.designno
left join t1 as b on b.id=t2.constructno
left join t1 as c on c.id=t2.qualityno
FROM 外键表 a INNER JOIN
主表 b ON a.designno = b.ID INNER JOIN
主表 c ON a.constructno = c.ID INNER JOIN
主表 d ON a.qualityno = d.ID忘了有三个字段