Hi Folks, now sitting here for 5 hours trying to get these stupid sql-request running, I decide to ask the list.
structual information of the database: database.preis = decimal(12,2), database.lfd=int(11), database.typ=varchar(30), database.marke=varchar(50) The following requests works select min(preis) from database also select min(preis) from database where marke='marke' and typ not like 'R%' and typ not like 'X%' but I have to get another value from the db so i choose select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesn´t bring the expected pair "preis / lfd" but all available "preis/lfd" grouped ascending. Any idea, even if I´m shure that the select worked tonight. TIA Oliver --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
