>

>UPDATE Menu
>  SET Count=ISNULL(A.RecordCount,0)+ISNULL(B.RecordCount,0)
>FROM
>(SELECT Menu.Numero,COUNT(*) AS RecordCount
>	FROM Menu
>	INNER JOIN MenuEntity ON Menu.Numero=MenuEntity.NoMenu
> INNER JOIN MenuPrivilege ON Menu.Numero=MenuPrivilege.NoMenu
> INNER JOIN MenuRole ON Menu.Numero=MenuRole.NoMenu
> INNER JOIN Member ON MenuEntity.NoEntity=Member.NoEntity AND
>  MenuPrivilege.NoType=Member.NoType AND MenuRole.NoRole=Member.NoRole
> WHERE Menu.Numero NOT IN (SELECT Menu.Numero FROM MenuPrivilegeExceptionCase
> INNER JOIN Menu ON MenuPrivilegeExceptionCase.NoMenu=Menu.Numero
> WHERE MenuPrivilegeExceptionCase.NoMember=Member.Numero)
> GROUP BY Menu.Numero) A
>FULL JOIN
> (SELECT Menu.Numero,COUNT(*) AS RecordCount
> FROM Menu
> INNER JOIN MenuPrivilegeExceptionCase ON Menu.Numero=MenuPrivilegeExceptionCase.NoMenu AND
>  MenuPrivilegeExceptionCase.Enabled=1
> INNER JOIN MenuEntity ON Menu.Numero=MenuEntity.NoMenu
> INNER JOIN Member ON MenuEntity.NoEntity=Member.NoEntity
> WHERE MenuPrivilegeExceptionCase.NoMember=Member.Numero
> GROUP BY Menu.Numero) B ON B.Numero = A.Numero
>WHERE Menu.Numero = ISNULL(A.Numero,B.Numero)
>

I would then assume that this approach is a little bit better as it simplifies a little bit the SQL command as I do not have to have an additional INNER JOIN as defined in message #1565063. Can you confirm this?