I suspect the problem is your misunderstanding of how the JOIN is working. I'm going to provide a MRE here, as your question lacks one. Firstly some sample data:

CREATE TABLE dbo.SomeTable (SomeID int,
                            SomeValue varchar(10));
GO
CREATE TABLE dbo.AnotherTable (AnotherID int,
                               SomeID int,
                               AnotherDate date);
GO

INSERT INTO dbo.SomeTable (SomeID,
                           SomeValue)
VALUES(1,'abc'),
      (2,'def'),
      (3,'ghi'),
      (4,'xyz');
GO
INSERT INTO dbo.AnotherTable (AnotherID,
                              SomeID,
                              AnotherDate)
VALUES (1, 1, GETDATE()),
       (2, 1, GETDATE() + 1),
       (3, 3, GETDATE() + 4),
       (4, 3, GETDATE() + 2),
       (5, 3, GETDATE() - 1),
       (6, 4, GETDATE() + 3);
GO

Now lets write a query that represents what your does:

SELECT S.SomeID,
       S.SomeValue,
       A.AnotherDate
FROM dbo.SomeTable S
     LEFT JOIN (SELECT TOP (1)
                       sq.SomeID,
                       sq.AnotherDate
                FROM dbo.AnotherTable sq
                ORDER BY sq.AnotherDAte DESC) A ON S.SomeID = A.SomeID;

This returns the following dataset:

This is expected, the subquery returns one row and then that is LEFT JOIN ed onto. We can see what the subquery would return with the following:

SELECT TOP (1)
       sq.SomeID,
       sq.AnotherDate
FROM dbo.AnotherTable sq
ORDER BY sq.AnotherDate DESC;

Which, unsurprisingly, returns the following:

This is because SomeID3 has the row with the highest value of AnotherDate and so in the priordata set only SomeID3 has a value in AnotherDate ( 1 , 2 , and 4 aren't equal to 3 so the LEFT JOIN doesn't return a row).

Perhaps what you want is instead of a JOIN is a correlated query. You need to use APPLY for this. As you have a LEFT JOIN , then presumably you need an OUTER APPLY . This would then return the TOP (1) row for each correlation:

SELECT S.SomeID,
       S.SomeValue,
       A.AnotherDate
FROM dbo.SomeTable S
    OUTER APPLY (SELECT TOP (1)
                      sq.AnotherDate
               FROM dbo.AnotherTable sq
               WHERE sq.SomeID = S.SomeID
               ORDER BY sq.AnotherDate DESC) A;

Which returns the following:

Though if this is your goal,you should just use a MAX (not sure that's the case here mind):

SELECT S.SomeID,
       S.SomeValue,
       MAX(A.AnotherDate) AS AnotherDate
FROM dbo.SomeTable S
    LEFT JOIN dbo.AnotherTable A ON S.SomeID = A.SomeID
GROUP BY S.SomeID,
         S.SomeValue;

Alternatively, you can use the Get top 1 row of each group solution.