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%'