Help with SQL query syntax

I have a table structure with queries that work on website, but would like to export some content out directly from the database. (So its a bit more complicated as it doesn’t have a revision details page already pulling through a single record’s details.

The table structure is:

Table: Revision

RevisionID
Revision
Status
etc

1, Delete Museum, 2 etc

Table: Profiles

ProfileID
Profile
Profile_Category
Category_Order

1, Museums, Places of Interest, 2 etc

Interlinking Table: revisionProfiles

ProfileID
RevisionID

1, 1

What I’m looking for in my query is all the fields from the Revision table plus the Profile field from the Profiles table, e.g.

1, Delete Museum, Museums

WHERE Revision.Status = 2 AND Category_Order = 2

There are a few Profile_Categories but for this category there will only ever be one Profile for any given Revision, e.g. Museums.

I’ve been playing around with it, but not sure of the syntax as there will be joins, and WHERE criteria from two of the tables involved.

Hope that makes sense.

Thanks.

SELECT r.RevisionID
     , r.Revision
     , r.Status
     , r.etc
     , p.Profile
  FROM Revisions AS r
INNER
  JOIN revisionProfiles AS rp
    ON rp.RevisionID = r.RevisionID
INNER
  JOIN Profiles AS p
    ON p.ProfileID = rp.ProfileID
   AND p.Category_Order = 2
 WHERE r.Status = 2   

Thank you - that’s perfect!