select id from 表一 where success = (select max(success) from 表一)
select A.id, A.success, B.other from 表一 A left join 表二 B on A.id = B.id where A.success = (select max(success) from 表一)
用view吧 似乎更合适你的要求,存储过程主要是用来insert和update的 view如下 select t2.* from t1 LEFT OUTER JOIN t2 ON t1.id= t2.id where t1.id=(select top 1 id from t1 order by success desc)
select A.id, A.success, B.other from 表一 A left join 表二 B on A.id = B.id where A.success = (select max(success) from 表一)
select aa.id,aa.success,bb.other from (select id, success from 表一 where success = (select max(success) from 表一)) aa left outer join 表二 bb on aa.id=bb.id
select A.id, A.success, B.other from 表一 A ,表二 B where on A.id = B.id and A.success = (select max(success) from 表一)
select A.id, A.success, B.other from 表一 A ,表二 B where A.id = B.id and A.success = (select max(success) from 表一)
select A.id, A.success, B.other from 表一 A left join 表二 B
on A.id = B.id
where A.success = (select max(success) from 表一)
似乎更合适你的要求,存储过程主要是用来insert和update的
view如下
select t2.* from t1 LEFT OUTER JOIN
t2 ON t1.id= t2.id where t1.id=(select top 1 id from t1 order by success desc)
on A.id = B.id
where A.success = (select max(success) from 表一)
(select id, success from 表一
where success = (select max(success) from 表一)) aa
left outer join 表二 bb
on aa.id=bb.id
on A.id = B.id and A.success = (select max(success) from 表一)