On Wed, 2007-01-17 at 11:47 -0600, Peter Brawley wrote: > Daniel, > > CREATE TABLE tbl ( > lab_number int(11) default NULL, > result int(11) default NULL, > release_time datetime default NULL > ); > select * from tbl; > +------------+--------+---------------------+ > | lab_number | result | release_time | > +------------+--------+---------------------+ > | 1 | 10 | 2007-01-17 00:00:00 | > | 1 | 20 | 2007-01-17 00:00:00 | > | 2 | 5 | 2007-01-17 00:00:00 | > | 2 | NULL | 0000-00-00 00:00:00 | > | 3 | NULL | 0000-00-00 00:00:00 | > | 4 | 25 | 0000-00-00 00:00:00 | > | 4 | 35 | 0000-00-00 00:00:00 | > +------------+--------+---------------------+ > > SELECT t1.lab_number,t1.result,t1.release_time > FROM tbl t1 > LEFT JOIN tbl t2 ON t1.lab_number=t2.lab_number AND t2.result IS NULL > WHERE t1.release_time=0 AND t2.lab_number IS NULL > > +------------+--------+---------------------+ > | lab_number | result | release_time | > +------------+--------+---------------------+ > | 4 | 25 | 0000-00-00 00:00:00 | > | 4 | 35 | 0000-00-00 00:00:00 | > +------------+--------+---------------------+ > > PB This works!! It seems it was my defaults for my original table that was causing me my problems. Sorry for troubling you, thanks once again for the prompt solution.
Danny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]