Orange Coast Database Forums

Magnets? I never heard of them, either. But here is a link to a really unusual learning tool - virtual "sticky magnets" from Head First Books. You rearrange them to create an SQL statement.

Have fun!

Here is  a script that uses grouping to only pull up the latest notes records. I took the liberty of simplifying the tables and used the actual use case name for the PK and FK to keep the number of fields to a minimum for my test build. The trick is to use a sub query to select the notes fields for the latest notes record. I tried it in Access and it should work in enterprise SQL's too.

SELECT useCases.name, useCases.description, useCases.start_date, useCaseNotes.description, useCaseNotes.note_date
FROM useCases INNER JOIN useCaseNotes ON useCases.name = useCaseNotes.useCaseName
WHERE (((useCaseNotes.note_date) In (SELECT Max(UseCaseNotes.note_date) AS MaxOfnote_date
FROM UseCaseNotes
GROUP BY UseCaseNotes.useCaseName;)));

HTH,

--Dan