Well first I want to excusse my poor english

I have the following problem

I have a database with 2 tables,
in the first table is a list of locations (id,name,bar1,bar2,bar3,bar4)
the second table has the informatiosn regardign the bars (id,name,street,etc)

now i created a query and get the location that i want the bar1 to bar4 fields now have the id of the corresponding bar in the bar table, my problem is how do i create a filter where i get the 4 names of the bar without having to run 4 querys.

Thanks in advance.

Ricardo