hi!

Here is an example with two tables, Titles and Authors. Check the code pal!

SELECT Authors.Author, Titles.Title, Titles.[Year Published]
FROM Titles INNER JOIN (Authors INNER JOIN [Title Author] ON Authors.Au_ID = [Title Author].Au_ID) ON Titles.ISBN = [Title Author].ISBN;

hope this can help you!