SELECT * FROM test1 JOIN test2 USING(IDPruef) JOIN test3 USING (IDCheck)