Hi

The second query should show them, but the problem would be that all
possible combinations will be shown.

As there is not a fixed number of exams that may be either the min or max,
the best solution is to do the transformations on the client.

John

"Paul" <paul_coombes_home@hotmail.com> wrote in message
news:19ca7866.0310280619.211d9fd2@posting.google.c om...
> Hi,
> Does anyone have any suggestions on the best to go about enforcing a
> relationship between two tables that exist within separate databases
> on the same SQL Server instance.