求查询语句 有四个表 表A(设备表) 表B(型号表) 表C(小类别表)表D(大类别表) 关系为 A.所属型号ID和B.ID对应 B.所属小类别ID和C.ID对应 C.所属大类别ID和D.ID对应 现在想查出某大类下(where D.id = ?)的设备,如何查询? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 他们依次是父子关系吗,如果是则如下写:select distinct A.ID from A,B,C,D where A.ID = B.ID and B.ID = C.ID and C.ID=D.ID and D.ID = XX select D.namefrom a,b,c,dwhere a.id=b.id and b.id=c.id and c.id=d.id; select A.* from A,B,C,D where A.ID = B.ID and B.ID = C.ID and C.ID = D.ID and D.ID = 'XX' select distinct A.ID from A,B,C,D where A.ID = B.ID and B.ID = C.ID and C.ID=D.ID and D.ID = XX Oracle数据库连接问题 java.sql.SQLException: 高分请高手解答关于oracle Autovue 控件的问题 一个修改语句 oracle的日期最终能以整数形式显示吗 oracle字段类型是字符,值是ip,如何判断大小 oracle安装求助,已经浪费我不少青春了,愿高手帮帮忙 ORA-12541:TNS:∶没有监听器? date問題 误删sys所有表,怎么办! oracle中对树形结构的查询,我想除了得到一列显示起始节点到当前节点的完整路径path外,还要有一列class2,如何实现? 关于一个比较复杂的行列互换的问题!oracle的PL/SQL
select distinct A.ID
from A,B,C,D
where A.ID = B.ID and B.ID = C.ID and C.ID=D.ID and D.ID = XX
from a,b,c,d
where a.id=b.id and b.id=c.id and c.id=d.id;
select A.*
from A,B,C,D
where A.ID = B.ID
and B.ID = C.ID
and C.ID = D.ID
and D.ID = 'XX'
from A,B,C,D
where A.ID = B.ID and B.ID = C.ID and C.ID=D.ID and D.ID = XX