I need some help on a query of 3 tables, doing joins I think.
The tables and fields are as follows
I need to display all the tasks and their subtasks along with the latest notes by adddate for the tasks and subtasks. There may not be any notes for either.
Task1, priority 1, 03-28-03, 03-28-03, 50%, almost done with task.
Sub of Task1, priority 4, 03-27-03, 03-28-03, 90%,
Task2, priority 2, 03-28-03, 03-28-03, 50%, almost done with task.
Task3, priority 1, 03-28-03, 03-28-03, 100%, done with task.
This is for oracle.