MS SQL - How to fix error - Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

Watch this example on YouTube:



In my case to fix replace:
Select RecordID, (Select Top 1 RecordID, AdditionalAccount From Table2 Where
Table1.RecordID = Table2.RecordID) As AdditionalRec
From Table1

With
Select RecordID, (Select Top 1 AdditionalAccount From Table2 Where
Table1.RecordID = Table2.RecordID) As AdditionalRec
From Table1