What are the challenges you face when working across database platforms? Take the survey

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?


Sign In or Register to comment.