Left Join example

   ALTER PROCEDURE security.getLeftNavbarByUserID    

    @UserID BIGINT    

AS      

BEGIN      

 -- Update the HasPermission column based on the user's access permissions

    --UPDATE LNT

    --SET HasPermission = CASE WHEN UA.CanAccess = 1 THEN 1 ELSE 0 END

    --FROM [dbo].[NavigationTabs] LNT

    --LEFT JOIN [dbo].[UserAccessEntity]  UA ON LNT.TabID = UA.TabID AND UA.UserID = @UserID;

    SELECT N.TabID, N.TabName,N.icon,N.link,N.UserID,N.Description,ISNULL(U.CanAccess,0) FROM  

[dbo].[NavigationTabs]  N    

  LEFT JOIN  [dbo].[UserAccessEntity]  U ON U.TabID=N.TabID    

  where U.UserID=@UserID    

 END 

-----------------------

Here left table i need all tabs list and alos join user access tabs only. forthis used Left Join