Mit MIN() in den Unterabfragen sollte das doch gehen:
anstelle vonPHP-Code:
(SELECT MIN(tel_number) FROM r3p02data/adr2
WHERE addrnumber=A.adrnr and consnumber='001' ) AS TEL1
usw.PHP-Code:
(SELECT tel_number FROM r3p02data/adr2
WHERE addrnumber=A.adrnr and consnumber='001' ) AS TEL1
Bookmarks