select a_name,y.bus_id from(select a_name from a union select a_name from b union select * from C)bb
inner join yehu y on bb.bus_id=y.bus_id where bb.a_name='bbbb1'
select a_name,y.bus_id from(select a_name from a union select a_name from b union select * from C)bb inner join yehu y on bb.bus_id=y.bus_id where bb.a_name='bbbb1'