(select model,price from pc where model in (select model from product where maker='B')) union (select model,price from laptop where model in (select model from product where maker='B')) union (select model,price from printer where model in (select model from product where maker='B'))
解决方案 »
- win7 64系统安装 oracle11g-64位版本报错什么原因?怎么解决?
- oracle10G的文本数据导入速度怎么才能和SQL的DTS一样?
- oracle 恢复
- 新生求助
- 写了个SQL自动生成工具,以提高开发数据库的效率,有兴趣的朋友欢迎来使用
- 登陆oms时 无法连接到management server localhost的错误
- 关于oracle导入失败后引发的问题,请大家帮帮忙!
- oracle查询条件,缩小范围最大的放在前面,还是,后面?
- 80分求救--奇怪 又 搞笑 的 oracle连接问题!!求救!!
- 如何进入 enterprise manager console?
- 请问哪里可以查到oracle的所有错误信息?
- 有一道应聘题:请写出几种登录远程数据库的方法?
from product p,pc
where p.model=pc.model
union
select p.model,price
from product p,laptop l
where p.model=l.model
union
select p.model,price
from product p,printer pt
where p.model=pt.model
UNION
SELECT MODEL,PRICE FROM LAPTOP WHERE MODEL IN (SELECT MODEL FROM PRODUCT WHERE MAKER='B' AND TYPE='LAPTOP')
UNION
SELECT MODEL,PRICE FROM PRINTER WHERE MODEL IN(SELECT MODEL FROM PRODUCT WHERE MAKER='B' AND TYPE='PRINTER')
谢谢。