Join or Sub Query?

[smti]

Hello, 

 

I could use a little help solving the following problem:

 

I have two tables: Counties and Products. The counties table contains a list of counties in which products are sold and the products table contains a list of products that are sold. I need to know the best way to write a query which produces a list products given the name of a county.

 

My table structure structure is as follows:

 

Table: Counties

CountyID

Name

 

Table: ProductBrands

BID

Brand

CountyID --> Foreign key relates to Counties.CountyID

 

 

I tried using a join statement; however, I seem to get erroneous results.

 

Any help would be greatly appreciated!

[Barand]

SELECT c.name, b. bid, b.brand

FROM counties c

    INNER JOIN productbrands b USING (countyid)

WHERE c.countyid = $id