I thought this would work,
SELECT *
FROM Patient_Text
INNER JOIN
(
SELECT *
FROM Patient
INNER JOIN Opnamen
ON Patient.PatNr = Opnamen.PatNr
)
ON Patient.PatNr = Patient_Text.PatNr
^^^^^^^^^^^^
But I get an error on the second use of Patient.PatNr.
Is there a way to get such a nested statement working ??
I'm looking for some construct that can used to generated code
from a visual design, through recursion of the links,
so it must be simple.
thanks,
--
cheers,
Stef Mientki
http://pic.flappie.nl
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
