select tport,fport,portname from boatapply ,vcode where fport = portcdode
select B.portname, C.portname from boatapply as A left join vcode as B on A.tport = B.portcode left join vcode as C on A.fport = C.portcode
我要select出:tport,fport的portname(名称)
select B.protname from boatapply A, vcode B where A.tport=B.portcode(+) or A.fport=B.portcode(+)
不好意思,写错了,那是oracle的 SQL应该是像 tj_dns(愉快的登山者) 写得那样,可能是用inner join 吧select B.portname, C.portname from boatapply as A inner join vcode as B on A.tport = B.portcode inner join vcode as C on A.fport = C.portcode
我是在oracle中的sql语句: 用: select B.protname from boatapply A, vcode B where A.tport=B.portcode(+) or A.fport=B.portcode(+) 这个不行的
left join vcode as B on A.tport = B.portcode
left join vcode as C on A.fport = C.portcode
select B.protname
from boatapply A, vcode B
where A.tport=B.portcode(+) or A.fport=B.portcode(+)
SQL应该是像 tj_dns(愉快的登山者) 写得那样,可能是用inner join 吧select B.portname, C.portname from boatapply as A
inner join vcode as B on A.tport = B.portcode
inner join vcode as C on A.fport = C.portcode
用:
select B.protname
from boatapply A, vcode B
where A.tport=B.portcode(+) or A.fport=B.portcode(+)
这个不行的