> Dear friends
Please do not send your messages as "urgent" to a mailinglist. It might be urgent to you, but not to the hundreds of people receiving your e-mail. > Im having some problems with this queries on mysql 4.1.15 > "SELECT * FROM scg00_scga2800_dbf WHERE taxdvig >= '20050302' OR (taxdvig = (SELECT max(taxdvig) FROM scg00_scga2800_dbf WHERE taxdvig < '20050302') AND (SELECT count(taxdvig) FROM scg00_scga2800_dbf WHERE taxdvig = '20050302') = 0) > What problem are you having? > is this query sybtax ok? > bellow the table structure > CREATE TABLE scg00_scga2800_dbf ( > taxdvig date default NULL, > taxcmpe double(5,2) default NULL, > taxenfi double(5,2) default NULL, > taxdtra date default NULL, > taxdt01 date default NULL, > taxpr01 double(7,4) default NULL, > taxdt02 date default NULL, > taxpr02 double(7,4) default NULL, > taxpr03 double(7,4) default NULL, > tax_iof double(7,4) default NULL, > sr_recno bigint(15) NOT NULL auto_increment, > sr_deleted char(1) NOT NULL default '', > UNIQUE KEY sr_recno (sr_recno), > KEY SCG00_SCGI2801_000007 (taxdvig,sr_recno), > KEY SCG00_SCGI2802_000008 (taxdtra,sr_recno) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1; > Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
