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:
1, Delete Museum, 2 etc
1, Museums, Places of Interest, 2 etc
Interlinking Table: revisionProfiles
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.
FROM Revisions AS r
JOIN revisionProfiles AS rp
ON rp.RevisionID = r.RevisionID
JOIN Profiles AS p
ON p.ProfileID = rp.ProfileID
AND p.Category_Order = 2
WHERE r.Status = 2
Thank you - that's perfect!