Could you suggest a way to do the following scenario:
only when these 2 conditions are false:
*Max(Updatedate) of TableB is before yesterday.(for example, if today is 5th of the month, Max(Updatedate) should be 3rd or before)
*Min(updatedate) of TableA should not be today or yesterday
There is no key between TableA and TableB.