Search results

Worked 16 years in IT related stuff until 2002 when I left the scene and trained as a nurse. Never regretted that for a minute, but now have a reporting requirement and decided I'd do a database myself so I'm back to all the frustrations I thought I'd left far behind.

I have three tables client, episode, notes there is a unique client id there are multiple episodes per client identified uniquely by date/time there are multiple notes per episode with a unique creation date/time I want to query joining the three tables and end up with one record that...