Subject Multiple rows in singleton select
Author Christian Gütter
Hi,

I have got a problem with the following query:

SELECT
V.ID,
[...]
V.Policennummer
FROM T_Vertraege V
LEFT OUTER JOIN T_Vertraege_II V2 ON (V.ID = V2.Z_Vertrags_ID)
LEFT OUTER JOIN T_VertragsTypen T ON (V.Z_VertragsTyp = T.ID)
LEFT OUTER JOIN P_Hole_Kunden_Name(V.Z_KID) P ON (V.Z_KID = O_KID)
LEFT OUTER JOIN T_PA_Pos PA ON (V.ID = PA.Z_Vertrags_ID)
WHERE V.ID IN (
SELECT Z_Vertrags_ID FROM T_PA_Pos_ZE WHERE Z_PA_ID = :PA_ID)
ORDER BY V.Policennummer

KeyLinks: T_Vertraege.ID



The query works fine so far, it shows the correct data and you can
edit the records. The only thing that does not work is a call