SELECT ... FROM a JOIN b ON ... JOIN c ON ... JOIN d ON ... SELECT * FROM A [INNER/LEFT/RIGHT/OUTER] JOIN B ON [a/b].IDCols = [a/b].IDCols [INNER/LEFT/RIGHT/OUTER] JOIN C ON [a/b/c].IDCols = [a/b/c].IDCols