You need to use JOIN to join both tables.
SELECT *
FROM dbo.bac A
INNER JOIN dbo.data B ON B.counter = A.counter
this should do it, but you need to filter your records as needed.
0
solved Merging tables in SQL Server
You need to use JOIN to join both tables.
SELECT *
FROM dbo.bac A
INNER JOIN dbo.data B ON B.counter = A.counter
this should do it, but you need to filter your records as needed.
0
solved Merging tables in SQL Server