Hi, I have an SQL query that has stumped me.
I have 2 tables, Projects and Tasks.
Each project has an original project ID with original tasks. What select query would produce the following output, with the original_finish_date coming from the the original project id task with the same task_id?
Example with data