select t.*,e.pm from a as t join b as e on t.party_id = e.party_id where not exists (select 1 from b where party_id = e.party_id and px > e.pm)
select * from b t where pm=(select max(pm) from b where party_id=t.party_id)
select a.party_id,t.name from a join b t on a.party_id = t.party_id and b.pm=(select max(pm) from b where party_id=t.party_id)
select *,b.pm,b.name from a jion b on a.party_id=b.party_id where pm=(select max(pm) from b) group by b.name
select top 1 a.party_id,pm,name from a,b on a.party_id = b.party_id order by DEC
1.select a.party_id,b.pm,b.name from a left join b on a.party_id = b.party_id where b.pm = max(pm) 2. select top 1 a.party_id,b.pm,b.name from a,b on a.party_id = b.party_id order by pm Dec
select t.*,e.pm
from a as t join b as e on t.party_id = e.party_id
where not exists (select 1 from b where party_id = e.party_id and px > e.pm)
where pm=(select max(pm) from b where party_id=t.party_id)
a.party_id,t.name
from
a join b t
on
a.party_id = t.party_id
and
b.pm=(select max(pm) from b where party_id=t.party_id)
2. select top 1 a.party_id,b.pm,b.name from a,b on a.party_id = b.party_id order by pm Dec