Subject | Multiple rows in singleton select |
---|---|
Author | Christian Gütter |
Post date | 2004-04-06T21:48:43Z |
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
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