Selecting from multiple tables using foreign keys

It's been a while since I've had to do any database development so if what I've done seems ridiculous please feel free to let me know. I've taken a spreadsheet and tried to convert it into a set of database tables, from what little about database development that I remember you're supposed to normalized your tables anywhere that there's a potential for repeating information.

I'm going to give a condensed version of my database tables so I don't need to type out a lot here

Tables:

Items
Columns(
  ItemID INT - PK
  CategoryID INT - FK
  TypeID INT - FK
  SupplierID - FK
  ItemName VARCHAR
  PurchaseDate DATETIME
)

Categories
Columns(
  CategoryID INT - PK
  CategoryName VARCHAR
)

Types
Columns(
  TypeID INT - PK
  TypeName VARCHAR
)

Suppliers
Columns(
  SupplierID INT - PK
  SupplierName VARCHAR
)

The Categories, Types, and Suppliers tables have been populated with data and what I'd like to do know is generate a query or stored procedure that will give me an output table like:

CategoryName | TypeName | SupplierName | ItemName | PurchaseDate
...

when I pass in a value for CategoryID/TypeID/SupplierID to the query/SP. I tried to do:

SELECT Categories.CategoryName, Types.TypeName, Suppliers.SupplierName, etc
   FROM Categories, Types, Suppliers, Items
WHERE Items.CategoryID = {integer value}

but this runs off into a never ending (I think) query that I had to cancel when it reached 20000+ records. Any advice on this would be greatly appreciated. Thanks.Start Free Trial