select * from table1,table2 where table1.id = table2.id and digperiod > GETDATE();