Join über 3 Tabellen

[DelphiDeveloper]

das muss doch so gehen!

Code:

SELECT ART.NR,ART.bez, SP.ID, SP.VP 
  FROM  ART, SP 
  WHERE (ART.ID=SP.ID_ART ) AND 
        (ID_KUNDE = 661) AND (VP <> 0) 
UNION 
SELECT ART.NR,ART.bez, ARTPG.ID, ARTPG.PG 
  FROM ART, ARTPG 
  WHERE (ART.ID=ARTPG.ID_ART) AND  
  (ID_KUNDE = 661) AND (VP = 0) 
ORDER BY 1

SORRY dein problem mit der ID_KUNDE hatte ich oben überlesen