菜鸟求助 sybase sql 语法

abbywl

麻烦大家给改下 谢谢了
select a.*,b.* from rl_unit_name a, (select user_id from rl_unit_name)b where a.id=b.id

Eisen

首先，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

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

Eisen

什么版本的?

snowpine

回复 1# abbywl


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


   

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'.

snowpine

回复 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

还是不行呀

snowpine

回复 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

派生表是得在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)