Re: SQL Query help

[Peter Brawley]

SELECT column1 FROM (
  SELECT * 
  FROM t 
  GROUP BY column1 
  HAVING count(*)=1
) AS tmp 
WHERE tmp.column2=0;

Edited 1 time(s). Last edit at 11/01/2007 12:43PM by Peter Brawley.