SQL CREATE VIEW komplexes Problem

[Pikachu]

Vielleicht so? (Angaben ohne Gewähr!)

CREATE VIEW V AS (                                           

SELECT NR, NAME, VALUE(TEL1,  '') AS TEL1,                   
                 VALUE(TEL2,  '') AS TEL2,                   
                 VALUE(TEL3,  '') AS TEL3,                   
                 VALUE(EMAIL1,'') AS EMAIL1,                 
                 VALUE(EMAIL2,'') AS EMAIL2,                 
                 VALUE(EMAIL3,'') AS EMAIL3 FROM (           

SELECT A.NR, A.NAME,                                

      (SELECT MIN(TEL)   FROM B WHERE B.NR=A.NR)   AS TEL1,  
      (SELECT MIN(TEL)   FROM B WHERE B.NR=A.NR    AND       
  TEL>(SELECT MIN(TEL)   FROM B WHERE B.NR=A.NR))  AS TEL2,  
      (SELECT MIN(TEL)   FROM B WHERE B.NR=A.NR    AND       
  TEL>(SELECT MIN(TEL)   FROM B WHERE B.NR=A.NR    AND       
  TEL>(SELECT MIN(TEL)   FROM B WHERE B.NR=A.NR))) AS TEL3,  

      (SELECT MIN(EMAIL) FROM C WHERE C.NR=A.NR)   AS EMAIL1,
      (SELECT MIN(EMAIL) FROM C WHERE C.NR=A.NR    AND       
EMAIL>(SELECT MIN(EMAIL) FROM C WHERE C.NR=A.NR))  AS EMAIL2,
      (SELECT MIN(EMAIL) FROM C WHERE C.NR=A.NR    AND      
EMAIL>(SELECT MIN(EMAIL) FROM C WHERE C.NR=A.NR    AND      
EMAIL>(SELECT MIN(EMAIL) FROM C WHERE C.NR=A.NR))) AS EMAIL3

                                           FROM A) AS X) 

[Pikachu]

Oder siehe auch dieses Thema.