Can you offset from a date in another table?

I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is offsetting a date based on a value in another table. For example, you have a hire date in an employee table. In another table, you have a record of employee sales that includes a date of sale for that employee. I want to make sure that all of these are later than the hire date. Is there a way to offset from that column which resides in a different table?
Tagged:
Answers
I'm afraid I can't think of a way to get this working with a column from another table.
I don't suppose there is any other date column in the same table that may indicate the start date or an appropriate date to start from?
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?