菜鸟求助 sybase sql 语法

snowpine

回复 1# abbywl


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


   

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 ))

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 )