Re: Full outer join

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Aug 2005 06:52:04 -0700
Message-ID: <1124977924.282479.302570@g44g2000cwa.googlegroups.com>

Jawahar, are you not just asking for a list of those patients who do not have N number of visits?

This is just a count(*) of visits by patient: select ... count from ... group by

You can join this to the other table if you want a list of the visits that the patient did make

If you need more help post the create tables with a few sample rows, but you really should be able to handle the solution using the hint above.

HTH -- Mark D Powell -- Received on Thu Aug 25 2005 - 08:52:04 CDT