select * from a Inner Join ( select * from b where y_id in( select y_id from b group by Company_name having count(*)=1) ) c On a.y_id=c.y_id
select a.y_id,a.e_id,a.e_category,a.title,a.pic_url1,a.startdate,a.enddate,a.recurring from A inner join ( select max(y_id) as y_id, Company_name from B group by Company_name) as B on A.y_id=B.y_id
select a.y_id,a.e_id,a.e_category,a.title,a.pic_url1,a.startdate,a.enddate,a.recurring, b.y_id ,b.Company_name,b.Company_City from A inner join ( select min(y_id) as y_id from B group by Company_name) as C on A.y_id=C.y_id inner join B on c.y_id =b.y_id
select a.y_id,a.e_id,a.e_category,a.title,a.pic_url1,a.startdate,a.enddate,a.recurring from A inner join ( select max(y_id) as y_id, Company_name from B group by Company_name) as B on A.y_id=B.y_id
select * from b where y_id in(
select y_id from b group by Company_name having count(*)=1)
) c
On a.y_id=c.y_id
from A
inner join (
select max(y_id) as y_id, Company_name from B group by Company_name) as B
on A.y_id=B.y_id
b.y_id ,b.Company_name,b.Company_City
from A
inner join (
select min(y_id) as y_id from B group by Company_name) as C
on A.y_id=C.y_id inner join B on c.y_id =b.y_id
from A
inner join (
select max(y_id) as y_id, Company_name from B group by Company_name) as B
on A.y_id=B.y_id