Re: Problem with querie

2006-06-01 Thread Martijn Tonies
> 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 (taxdv

Problem with querie

2006-05-31 Thread culikr
Dear friends 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'