help...new to queries

[Private User]

I want to write a simple query using the pubs database.

I want to show title, au_fname, au_lname

there is no link between titles and authors though. there is a titleauthor
table that links the 3 tables together, but i do not know how to write this
query. can someone tell me the right query language?

thanks

 

[Jeff L]

Well, you could use the query wizard to make your query. Select all
three of your tables and join them together. If you want to write your
own SQL:

Select FieldNames

From (Titles Inner Join TitleAuthor ON Titles.TitleID =

TitleAuthor.TitleID)
Inner Join Authors ON Authors.AuthorID = TitleAuthor.AuthorID
Where YourCriteriaHere

Hope that helps!

 

[Ofer Cohen]

In this link you find some examples, and explanations on how to write SQL

http://www.databasedev.co.uk/microsoft-access-sql.html