Stef Mientki wrote:
thanks guys,
for the fast and different responses,
I really appreciate that.
... now I need a couple hours to study all your ideas.
After studying all your suggestions, I must conclude
that my knowledge of SQL is too low to create a real fool proof solution.
For the
thanks guys,
for the fast and different responses,
I really appreciate that.
... now I need a couple hours to study all your ideas.
--
cheers,
Stef Mientki
http://pic.flappie.nl
-
To unsubscribe, send email to [EMAIL
give the nested select an alias so you can reference it:
SELECT *
FROM Patient_Text
INNER JOIN
(
SELECT *
FROM Patient
INNER JOIN Opnamen
ON Patient.PatNr = Opnamen.PatNr
) N
ON N.PatNr = Patient_Text.PatNr
But if this is your actual query then I would suggest either joining
Stef Mientki wrote:
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
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
5 matches
Mail list logo