结果和 select a.NumberType,b.like,d.NumberType from a,b,c,a d where b.link=c.like and b.Revoperator=a.NumberTypeID and c.operator=d.NumberTypeID 是一样的,如果这一定要那样 select * from (select b.*,c.operator from b left join c on b.link=c.link)Tem,a aa,a bb where aa.NumberTypeID=tem.Reoperator and bb.NumberTypeID=tem.operator
select b.RevOperator ,b.Link ,c.Operator from a left join a on a.NumberTypeID=b.RevOperator left join on b.link=c.link
我只会写第一种,但不太理解 select * from (select b.*,c.operator from b left join c on b.link=c.link)Tem,a aa,a bb where aa.NumberTypeID=tem.Reoperator and bb.NumberTypeID=tem.operator
select a.NumberType,b.like,d.NumberType from a,b,c,a d where b.link=c.like and b.Revoperator=a.NumberTypeID and c.operator=d.NumberTypeID
是一样的,如果这一定要那样
select * from
(select b.*,c.operator from b left join c on b.link=c.link)Tem,a aa,a bb
where aa.NumberTypeID=tem.Reoperator and bb.NumberTypeID=tem.operator
,c.Operator from a left join a on a.NumberTypeID=b.RevOperator left join on b.link=c.link
select * from
(select b.*,c.operator from b left join c on b.link=c.link)Tem,a aa,a bb
where aa.NumberTypeID=tem.Reoperator and bb.NumberTypeID=tem.operator