select * from (select a.no,c.name from a,c where a.no *=c.no ) temp ,b where temp.name=b.name这样写也不行 救命啊
select * from a, b, c where a.no+b.name *=c.no+c.name这样可以吗
select * from a, b, c where a.no *=c.no and b.name=c.name ==> select * from a inner join c on a.no =c.no cross join b where b.name=c.name
想要什么结果? select * from a left join c on a.no = c.no inner join b on b.name =c.name select * from a inner join c on a.no =c.no cross join b where b.name=c.name
select * from a left join b on a.no=b.no left join c on c.no=a.no
==>
select * from a inner join c on a.no =c.no
cross join b where b.name=c.name
select * from a left join c on a.no = c.no inner join b on b.name =c.name
select * from a inner join c on a.no =c.no cross join b where b.name=c.name