Think I got it working like so:
SELECT DirectoryID, Title, Summary, Image, DirCatCategoryID, DirStyleStyleID, DirAgeAgeID, DirLocLocationID FROM Directory INNER JOIN DirCat ON DirCat.DirCatDirectoryID = Directory.DirectoryID INNER JOIN DirStyle ON DirStyle.DirStyleDirectoryID = Directory.DirectoryID INNER JOIN DirAge ON DirAge.DirAgeDirectoryID = Directory.DirectoryID INNER JOIN DirLoc ON DirLoc.DirLocDirectoryID = Directory.DirectoryID WHERE Approved = 'Y' GROUP BY DirectoryID