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.