Hi All,

I have an SQL statement in ElevateDB that uses MAX and a sub select. How can
I do the following in DBISAM ?

SELECT
  *,
  (SELECT MAX(ContactDate)
   FROM D2DContacts
   WHERE PatientID = C.PatientID) AS LastContact
FROM
  Patients C


Thanks,
Paul

Paul,

Here is what you need:

SELECT
  C.*, MAX(P.ContactDate) AS LastContact
FROM
  Patients C
  LEFT OUTER JOIN D2DContacts D ON D.PatientID = C.PatientID
GROUP BY
  PatientID

--
Fernando Dias
[Team Elevate]

Hi Fernando,

thanks very much for the help.

Cheers,
Paul

"Fernando Dias" <fernandodias.removthis@easygate.com.pt> wrote in message
news:825BFA88-11EF-4565-B2A9-06621997722C@news.elevatesoft.com...
> Paul,
>
> Here is what you need:
>
> SELECT
>   C.*, MAX(P.ContactDate) AS LastContact
> FROM
>   Patients C
>   LEFT OUTER JOIN D2DContacts D ON D.PatientID = C.PatientID
> GROUP BY
>   PatientID
>
> --
> Fernando Dias
> [Team Elevate]
>

Paul,

<< I have an SQL statement in ElevateDB that uses MAX and a sub select. How
can I do the following in DBISAM ? >>

I knew it would happen eventually, but I think that's the first of that type
of question (EDB --> DBISAM).

--
Tim Young
Elevate Software
www.elevatesoft.com