How to choose the required DateTime?

Question

SQL Server

How to select one table (A) id, where Datetime will be taken from another table (B) in between.
Between DatetimeB and DatetimeB -10 hours.

Select A.id
  From Accounts A
    join Boo B on A.id =  B.id and A.datetime between B.datetime -'10:00' and B.datetime

Answer 1

SELECT Accounts.id
  FROM Accounts
    INNER JOIN Boo ON Accounts.id = Boo.id
  WHERE Accounts.[datetime] BETWEEN DATEADD(hh, -10, Boo.[datetime]) AND Boo.[datetime]