有三张表:
te_vehicletarget
tr_tmn_vehicle
te_terminal
我要查询的是
te_vehicletarget表下的
te_vehicletarget.reg_date,te_vehicletarget.open_date,te_vehicletarget.close_date;
tr_tmn_vehicle表下的
tr_tmn_vehicle.bindtime
where条件 tr_tmn_vehicle.SU_MDN = ' ';
关联为:te_vehicletarget.ID = tr_tmn_vehicle.VHC_ID;
te_terminal.ID = tr_tmn_vehicle.TMn_ID
但是我想了一下午也没有想明白!
te_vehicletarget
tr_tmn_vehicle
te_terminal
我要查询的是
te_vehicletarget表下的
te_vehicletarget.reg_date,te_vehicletarget.open_date,te_vehicletarget.close_date;
tr_tmn_vehicle表下的
tr_tmn_vehicle.bindtime
where条件 tr_tmn_vehicle.SU_MDN = ' ';
关联为:te_vehicletarget.ID = tr_tmn_vehicle.VHC_ID;
te_terminal.ID = tr_tmn_vehicle.TMn_ID
但是我想了一下午也没有想明白!
解决方案 »
- oracle 如何列转行,高手帮忙
- 请教下这个需求如何更好的实现
- oracle 语句比较
- 求还原oracle数据库的方法
- 用数组作为oracle参数该怎么写?
- SYS与SYSTEM的区别
- #我在机器上装了oracle 9i,后装了plsql,连接服务器上的oracle8,但在 PLSQL里面的中文是乱码,请问:如何显示中文?
- net8无法安装,
- 如何更改表名?
- 我用的Developer/2000开发,数据块里的"from子查询"是怎么用法?(特急!在线等待!)
- Oracle 11g 没有dbconsole 服务
- oracle中新建了一个用户,不能在sql developer中使用select语句
te_vehicletarget.reg_date,te_vehicletarget.open_date,te_vehicletarget.close_date
from
te_vehicletarget,
tr_tmn_vehicle,
te_terminal
where te_vehicletarget.ID = tr_tmn_vehicle.VHC_ID;
and te_terminal.ID = tr_tmn_vehicle.TMn_ID
and tr_tmn_vehicle.SU_MDN = ' '
SELECT te_vehicletarget.reg_date,te_vehicletarget.open_date,te_vehicletarget.close_date, tr_tmn_vehicle.bindtime
FROM ttr_tmn_vehicle,te_terminal,e_vehicletarget
where tr_tmn_vehicle.SU_MDN = ' ' AND te_vehicletarget.ID = tr_tmn_vehicle.VHC_ID AND te_terminal.ID = tr_tmn_vehicle.TMn_ID
tr_tmn_vehicle n条
te_terminal p条
做连接m*n*p条,
where条件,就是将这m*n*p条数据中的每条数据进行过滤,符合的留下,不符合的过滤……
from
te_vehicletarget a,tr_tmn_vehicle b,te_terminal c
where
a.te_vehicletarget.ID = b.tr_tmn_vehicle.VHC_ID
and
a.te_terminal.ID = b.tr_tmn_vehicle.TMn_ID
and
b.tr_tmn_vehicle.SU_MDN = ''
te_vehicletarget.open_date,
te_vehicletarget.close_date,
tr_tmn_vehicle.bindtime
from te_vehicletarget
inner join tr_tmn_vehicle on te_vehicletarget.ID = tr_tmn_vehicle.VHC_ID
inner join te_terminal on te_terminal.ID = tr_tmn_vehicle.TMn_ID
where te_terminal.SU_MDN in ('','','','','','');