On 3/1/2011 6:47 PM, Jeff Archer wrote: > I think it will just happen to work out if I could get the first row > for each ImageID since the values should have been entered in > ascending order. I realize this will probably not be guaranteed to > get lowest X,Y but for my purpose at the moment this is OK.
select * from Defects, Images where Defects.DefectID = ( select min(d2.DefectID) from Defects d2 where d2.ImageId = Images.ImageId ); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users