I have a derivative table without a timestamp column. I want to view the last 7 days updated data in the table.
I also have a parent table (Foreign key : ID with the derivative table) which has a timestamp column.

How do I join both to get the incremental records for the derivative table in SQL?

I tried the given script however it resulted in an error

select COM_PHYSICAL_PDF_BLOB.* from COM_PHYSICAL_PDF_BLOB cppb where COM_PHYSICAL_FILE.UPDATE_DATE < 2023-02-07 07:30:02.000
inner join COM_PHYSICAL_FILE on COM_PHYSICAL_FILE.ID = COM_PHYSICAL_PDF_BLOB.ID