菜鳥求助 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)