• Since 'File ID' is on all three tables you should be able to join using that, then just pull in the values from each table.

    Select a.*, b.*, c.*

    from table_1 a

    inner join table_2 b on

    a.file_id = b.file_id

    inner join table_3 c on -- changed to table_3

    a.file_id = c.file_id

    Just add a where clause to pull just the dates you want, or something like this if I'm understanding this.

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.