Hi team,

I encountered an error when i called a sub Query with in a ISNULL() in SQL query Syntax in SQL Obecjt Advance Query.

Kindly Help

here is the sample query:

SyntaxEditor Code Snippet

SELECT  {User}.[Id], 
        {User}.[Username], 
        ISNULL({TimelineLockingByUsers}.[AppraiserEditModeFromDate], SELECT {Timelines}.[AppraiserEditModeFromDate] FROM {Timelines} WITH(NOLOCK) WHERE {Timelines}.[Id] = @TimelineId) AS EditModeFromDate, 
        ISNULL({TimelineLockingByUsers}.[AppraiserEditModeTillDate], SELECT {Timelines}.[AppraiserEditModeTillDate] FROM {Timelines} WITH(NOLOCK) WHERE {Timelines}.[Id] = @TimelineId) AS EditModeTillDate
FROM {User} WITH(NOLOCK) 
        INNER JOIN {UserRelations} WITH(NOLOCK) ON {User}.[Id] = {UserRelations}.[UserId]
        LEFT JOIN {TimelineLockingByUsers} WITH(NOLOCK) ON  {UserRelations}.[Id] = {TimelineLockingByUsers}.[UserRelationId] 
                                                        AND {TimelineLockingByUsers}.[TimelineId] = @TimelineId
        WHERE {UserRelations}.[AppraiserId] = @AppraiserId