join based on more than 2 tables SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a JOIN table2 b ON a.ID = b.ID JOIN table3 c ON a.ID = c.ID WHERE a.ID >= 1000;