I have 2 tables:

Downtime Categories:
`CatID ----- CatName ----- SiteID`

Downtimes:
`DtID ----- DtName ----- CatID`

How do I create a query so I can pull all of the records from Downtimes where the SiteID from Downtime Categories = x?

I don't know how to word this search to get what I need, I have tried all the Joins but none of them give me what I'm after

Any help would be appreciated, thanks

Edit:
I have tried all variants of the below answers but none of them worked... copying one into SMS and running it now worked first time :(
I must have had a typo somewhere...stupid...
Thanks for the replies