Supportnet Computer
Planet of Tech

Supportnet / Forum / Anwendungen(Java,C++...)

SQL Abfrage optimieren





Frage

Wie könnte man folgendes SQL Statement optimieren? [code]SELECT DISTINCT p.PER_ID, p.PER_FIRST_NAME, p.PER_LAST_NAME, (SELECT TRVL_ID FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%to%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as anreise, (SELECT TRVL_CONF FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%to%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as anreise_conf, (SELECT TRVL_ID FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%back%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as rückreise, (SELECT TRVL_CONF FROM PEV_TRAVEL WHERE TRVL_CONF LIKE ´%back%´ AND TRVL_ID in (SELECT TRVL_ID FROM PEV_BOOKING_TRAVEL WHERE PER_ID = p.PER_ID)) as rückreise_conf, p.PER_FMNO_CNO FROM (VW_T_PERSON p INNER JOIN PEV_BOOKING_TRAVEL pbt ON p.PER_ID = pbt.PER_ID) ORDER BY p.PER_LAST_NAME[/code]

Antwort 1 von Newan

sag aml welche DB....da gibbet unterschiede!

Ich möchte kostenlos eine Frage an die Mitglieder stellen:


Ähnliche Themen:


Suche in allen vorhandenen Beiträgen: