Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=

Question

I am trying to fetch the data in three tables by using their version columns.

HERE IS MY CODE:

INSERT INTO [dbo].tblCALPLA(ACCOUNT,DATASRC,VERSION)

SELECT ACCOUNT,DATASRC,VERSION FROM [dbo].TBLFACT
WHERE VERSION=(SELECT ID FROM [dbo].VERSION)

UNION

SELECT ACCOUNT,DATASRC,VERSION FROM [dbo].TBLFACT1
WHERE VERSION=(SELECT ID FROM [dbo].VERSION)

UNION

SELECT ACCOUNT,DATASRC,VERSION FROM [dbo].TBLFACT2
WHERE VERSION=(SELECT ID FROM [dbo].VERSION)

Answer 1

In all your WHERE conditions, instead of

WHERE Version = (SELECT ID ...)

make use of

WHERE Version IN (SELECT ID...)