On Tue, 2005-06-07 at 12:16, Jaime Casanova wrote:
SELECT encounter.encounter_id, encounter_d.encounter_d_id
FROM encounter
JOIN encounter_d on encounter_d.encounter_id = encounter.encounter_id
EXCEPT
SELECT encounter.encounter_id, encounter_d.encounter_d_id
FROM encounter
JOIN
SELECT encounter.encounter_id, encounter_d.encounter_d_id
FROM encounter
JOIN encounter_d on encounter_d.encounter_id = encounter.encounter_id
EXCEPT
SELECT encounter.encounter_id, encounter_d.encounter_d_id
FROM encounter
JOIN encounter_d on encounter_d.encounter_id =
On Tue, Jun 07, 2005 at 12:42:47PM -0500, Scott Marlowe wrote:
On Tue, 2005-06-07 at 12:16, Jaime Casanova wrote:
I suppose this is because the columns in the except are the same that
the ones in the main select and the order by get confused.
i'm redirecting to hackers to know if this is