access DB triple join query...

[nerf]

Hi, yep im stuck, I made this query here
select * from PRODUCTS inner join link on link.prodID = PRODUCTS.productID where link.sysID=1
that joins 2 tables, i need to acquire more information off that query.
I have a category table, where the fields are ID & name and the PRODUCTS table has a field called CategoryID so basically (and im not sure how to) i want to modify my exisiting query so i can set a categoryID aswell as link.sysID=1

So basically i can then show each product under a header for its category where sysID=1

In short the result would be like:

System ID 1 has 2 Categories
CATEGORY 1
product 1
product 2
CATEGORY 2
product 3
product 4

[r937]

select columns
     , category.ID   as category_ID
     , category.name as category_name
  from PRODUCTS 
inner 
  join link 
    on PRODUCTS.productID 
     = link.prodID 
   and link.sysID
     = 1
inner
  join category
    on PRODUCT.CategoryID
     = category.ID