Hi

Let's consider next case:

Tables: Sales 1<--> m Products 1<-->1 Country

Select *

FROM

Sales s

inner join Products p on s.ProductId = p.ProductId

inner join Country c on p.MadeInCountryId = c.CountryId

WHERE CountryName like 'A%'

OR

Select *

FROM

Sales s

inner join Products p

inner join Country c on p.MadeInCountryId = c.CountryId

on s.ProductId = p.ProductId

WHERE CountryName like 'A%'