fetch first (vor Where)???

[svt]

Hallo Tobi,

anbei das SQL:
SELECT TPANR1, TPNBHF, TPBENR, TPIDEN, TPKMEN, TPVORT, TPVREG, TPVHOR, TPVVER, TPBMEN

FROM brkdatv6.phisttp

fetch first 500 rows only


WHERE tpkonz='LCV' And TPVART='PAZ' And TPNBHF='PACKSTUBE'

ORDER BY TPANR1 DESC , TPBENR, TPZUNR, TPTIA, TPPALN, TPANRP



Gruß
svt