Chinaunix

标题: 菜鸟求助 sybase sql 语法 [打印本页]

作者: abbywl 时间: 2012-09-05 16:36
标题: 菜鸟求助 sybase sql 语法
麻烦大家给改下谢谢了
select a.*,b.* from rl_unit_name a, (select user_id from rl_unit_name)b where a.id=b.id

作者: Eisen 时间: 2012-09-05 16:47
首先，rl_unit_name里面有id这个字段吗?如果有那么就写成
select a.*,b.* from rl_unit_name a, (select user_id from rl_unit_name)b where a.id=b.user_id
或
select a.*,b.user_id from rl_unit_name a, (select id,user_id from rl_unit_name)b where a.id=b.id

作者: abbywl 时间: 2012-09-06 08:52
本帖最后由 abbywl 于 2012-09-06 08:53 编辑

非常感谢2楼可是这样写回报异常 Incorrect syntax near the keyword 'select'.
貌似sybase不支持 (select user_id from rl_unit_name)b 这样写
应该怎么写呢

作者: Eisen 时间: 2012-09-06 09:53
什么版本的?

作者: snowpine 时间: 2012-09-06 10:47
回复 1# abbywl

select a.*,b.user_id from rl_unit_name a, rl_unit_name b where a.id=b.id

作者: abbywl 时间: 2012-09-06 10:56
本帖最后由 abbywl 于 2012-09-06 10:57 编辑

版本12.5，原语句是这样滴
select a.* from rl_unit_name a,
(select max(un_name_date) un_name_date ,un_inner_code from rl_unit_name group by un_inner_code) b where
a.un_inner_code=b.un_inner_code and a.un_name_date=b.un_name_date
报错Incorrect syntax near the keyword 'select'.

作者: snowpine 时间: 2012-09-06 11:02
回复 6# abbywl

版本12.5，原语句是这样滴
select a.* from rl_unit_name a,
(select max(un_name_date) un_name_date ,un_inner_code from rl_unit_name group by un_inner_code) b where
a.un_inner_code=b.un_inner_code and a.un_name_date=b.un_name_date
报错Incorrect syntax near the keyword 'select'.

select a.* from rl_unit_name a where a.un_inner_code in (select max(un_name_date) from rl_unit_name group by un_inner_code ))

作者: abbywl 时间: 2012-09-06 11:28
还是不行呀

作者: snowpine 时间: 2012-09-06 11:33
回复 8# abbywl

select a.* from rl_unit_name a where a.un_inner_code in (select max(un_name_date) from rl_unit_name group by un_inner_code )

作者: Eisen 时间: 2012-09-06 14:18
派生表是得在ASE15里面才有的，你这12.5是还没有
select a.* from rl_unit_name a,
(select max(un_name_date) un_name_date ,un_inner_code from rl_unit_name group by un_inner_code) b where
a.un_inner_code=b.un_inner_code and a.un_name_date=b.un_name_date
可以写成
select * from rl_unit_name
group by un_inner_code
having un_name_date=max(un_name_date)

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)