Thank you Drew for the information. This is consistent with my recent
research. I would like to confirm with you that the query you sent uses
the syntax understood by Base/HSQL
> To get both docotors and the patient into a result set you need to use a
> query such as
>
> SELECT
> "Medical Doctor"."Surname" AS "Doctor",
> "Patient"."Surname" AS "Patient"
> FROM { OJ "Medical Doctor" LEFT OUTER JOIN "Patient" ON "Medical
> Doctor"."ID Number" = "Patient"."Medical Doctor ID" }
>
>
>
> more later..
>
> Drew
I would guess that OJ means "Outer Join" and that it is not by chance that
you are using the key words "LEFT OUTER JOIN" and that "Medical
Doctor"."ID Number" is at the left of the clause.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org
For additional commands, e-mail: dev-h...@documentation.openoffice.org
