Can you offset from a date in another table?

slimshaky

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?

Jessica R

Hi there,

I'm afraid I can't think of a way to get this working with a column from another table. (There is an example on how to offset based on a date in another column of the same table here: https://www.red-gate.com/hub/product-learning/sql-data-generator/generating-realistic-dates-using-sql-data-generator-and-python)

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?