Hi,

Is it possible to do this...

SELECT
    g.GroupID,
    g.GroupName,
    FolderPermissionID1,
    FolderPermissionID2,
    FolderPermissionID3,
    FolderPermissionID4,
    FolderPermissionID5,
    FolderPermissionID6,
    FolderPermissionID7,
    FolderPermissionID8,
    FolderPermissionID9,
    FolderPermissionID10    
FROM
    tbl_Groups g
LEFT OUTER JOIN
    (
        SELECT 
            *
        FROM
            GroupFolderPermissions
        WHERE
            folderID = 6
    ) gfp
ON
    g.GroupID = gfp.GroupID

In particular, I want to join to the 'GroupFolderPermissions' entity only _ after_ it has been filtered.

Cheers, I.

Ian,

Dynamic/Derived table joins are not supported. You can rewrite your query like:

SELECT
    g.GroupID,
    g.GroupName,
    FolderPermissionID1,
    FolderPermissionID2,
    FolderPermissionID3,
    FolderPermissionID4,
    FolderPermissionID5,
    FolderPermissionID6,
    FolderPermissionID7,
    FolderPermissionID8,
    FolderPermissionID9,
    FolderPermissionID10    
FROM    tbl_Groups g
LEFT OUTER JOIN GroupFolderPermissions gfp 
               ON g.GroupID = gfp.GroupID AND folderID = 6

and achieve the same results.

Yes, that's great thanks.