SQL Server query joins with dates

Question

I am trying to join two tables using Dates but I want the join to be:

table1.date = (table2.date + 1)

Is this possible?

Answer 1

USE DATEADD FUNCTION

on table1.date = dateadd(dd,1,table2.date)