这句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/07/19 13:41:51
![这句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](/uploads/image/z/12580963-43-3.jpg?t=%E8%BF%99%E5%8F%A5sql%E8%AF%AD%E5%8F%A5%E6%80%8E%E4%B9%88%E6%94%B9%E6%88%90left+join%E7%9A%84select+%E8%A1%A82.a+as+a%2C%E8%A1%A82.a+as+b%2C%E8%A1%A83.a+as+c+from+%E8%A1%A81+a%2C%E8%A1%A82+b%2C%E8%A1%A82+c%2C%E8%A1%A83+dwhere+a.%E6%9D%A1%E4%BB%B6%EF%BC%88%2B%EF%BC%89%3Db.%E6%9D%A1%E4%BB%B6and+a.%E6%9D%A1%E4%BB%B6%EF%BC%88%2B%EF%BC%89%3Dc.%E6%9D%A1%E4%BB%B6and+d.%E6%9D%A1%E4%BB%B6%EF%BC%88%2B%EF%BC%89%3Dc.%E6%9D%A1%E4%BB%B6%E5%8F%AF%E8%83%BD%E5%86%99%E9%94%99%E4%BA%86%2C%E5%BA%94%E8%AF%A5%E6%98%AF%E8%BF%99%E6%A0%B7%E7%9A%84%2C%E6%8A%B1%E6%AD%89select)
这句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.条件