Auf Thema antworten

Beitrag

Hy,

probie das hier mal...

[CODE]

Select mastertabelle.*,
s.beliebiger_Wert

FROM
(

SELECT tabelle.LFD_NR,
max(tabelle.ID) AS ID

FROM ( SELECT DATEN.LFD_NR,
DATEN.SORT_NR,
STAMM.ID,
DATEN.ID
FROM STAMM
INNER JOIN [PATH] ON STAMM.ID = [PATH].ID
INNER JOIN DATEN ON [PATH].VORGAENGER_ID = DATEN.ID
WHERE STAMM.ID = 21793
) tabelle
GROUP BY tabelle.LDF_NR

) mastertabelle
JOIN STAMM s ON s.ID = mastertabelle.ID

[/CODE]

Lg

<blockquote data-quote="PLSQL_SQL" data-source="post: 3045" data-attributes="member: 488">Hy,&nbsp;probie das hier mal...&nbsp;[CODE]&nbsp;Select mastertabelle.*,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s.beliebiger_Wert&nbsp;FROM(&nbsp;SELECT&nbsp; &nbsp; tabelle.LFD_NR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; max(tabelle.ID) AS ID&nbsp;FROM&nbsp; &nbsp; (&nbsp; &nbsp; SELECT&nbsp; &nbsp; DATEN.LFD_NR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATEN.SORT_NR,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; STAMM.ID,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATEN.ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM&nbsp; &nbsp; STAMM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INNER JOIN [PATH] ON STAMM.ID = [PATH].ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INNER JOIN DATEN ON [PATH].VORGAENGER_ID = DATEN.ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE&nbsp; &nbsp; STAMM.ID = 21793&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) tabelleGROUP BY tabelle.LDF_NR&nbsp;) mastertabelle&nbsp; JOIN STAMM s ON s.ID = mastertabelle.ID&nbsp;[/CODE]&nbsp;Lg</blockquote>

[QUOTE="PLSQL_SQL, post: 3045, member: 488"] Hy, probie das hier mal... [CODE] Select mastertabelle.*, s.beliebiger_Wert FROM ( SELECT tabelle.LFD_NR, max(tabelle.ID) AS ID FROM ( SELECT DATEN.LFD_NR, DATEN.SORT_NR, STAMM.ID, DATEN.ID FROM STAMM INNER JOIN [PATH] ON STAMM.ID = [PATH].ID INNER JOIN DATEN ON [PATH].VORGAENGER_ID = DATEN.ID WHERE STAMM.ID = 21793 ) tabelle GROUP BY tabelle.LDF_NR ) mastertabelle JOIN STAMM s ON s.ID = mastertabelle.ID [/CODE] Lg [/QUOTE]

Authentifizierung