SQL Question

Hello Oracle Guru's,

        I've got a nasty problem that I'm appealing for help with. I want to create a view in a ProC program that joins two tables. There are two fields that are relevent to my question, PATIENT, which is a unique ID similar to employee number, and VISIT. VISIT is a date field in the other table and for each PATIENT record there can be several VISIT records.
Here's the problem:

        In my view I want each record to contain the PATIENT field and THE MOST RECENT VISIT field for that patient.

        I've tried using variations on the MAX function but group functions are not allowed in CREATE statements. Is there some way to do it or am I SOL?

Thanx in advance,

dorian_at_eng.umd.edu Received on Wed Sep 01 1993 - 22:09:38 CEST