这句sql语句怎么改成left join的select 表2.a as a,表2.a as b,表3.a as c from 表1 a,表2 b,表2 c,表3 dwhere a.条件(+)=b.条件and a.条件(+)=c.条件and d.条件(+)=c.条件可能写错了,应该是这样的,抱歉select
来源:学生作业帮助网 编辑:六六作业网 时间:2024/11/27 23:00:17
这句sql语句怎么改成left join的select 表2.a as a,表2.a as b,表3.a as c from 表1 a,表2 b,表2 c,表3 dwhere a.条件(+)=b.条件and a.条件(+)=c.条件and d.条件(+)=c.条件可能写错了,应该是这样的,抱歉select
这句sql语句怎么改成left join的
select 表2.a as a,表2.a as b,表3.a as c from 表1 a,表2 b,表2 c,表3 d
where a.条件(+)=b.条件
and a.条件(+)=c.条件
and d.条件(+)=c.条件
可能写错了,应该是这样的,抱歉
select 表2.a as a,表2.a as b,表3.a as c,表4.b as d from 表1 a,表2 b,表2 c,表3 d,表4 e
where a.条件(+)=b.条件
and a.条件(+)=c.条件
and d.条件(+)=c.条件
and e.条件(+)=a.条件
这句sql语句怎么改成left join的select 表2.a as a,表2.a as b,表3.a as c from 表1 a,表2 b,表2 c,表3 dwhere a.条件(+)=b.条件and a.条件(+)=c.条件and d.条件(+)=c.条件可能写错了,应该是这样的,抱歉select
select 表2.a as a,表2.a as b,表3.a as c
from 表1 as a
left join 表2 as b on a.条件(+)=b.条件
left join 表2 as c on a.条件(+)=c.条件
left join 表3 as d on d.条件(+)=c.条件