Sorry,
where teilenr = a.teilenr of course… Hello everybody, today perhaps I have a simple question. In a table there are the following fields: Partnumber; quantity; price ABC; 1; 115€ ABC; 10; 100€ ABC; 20; 80€ Now I would like one sql-query-result, the price for the greatest quantity. I have the following: SELECT PREIS FROM TSTAFFELPREISE a where TEILENR ='210094LG' and vanz = (select max(vanz) from tstaffelpreise where teilenr Is there an better way to get the result? Thanks in advance. Best regards Olaf [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
