help...new to queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 =
Click to expand...
TitleAuthor.TitleID)
Inner Join Authors ON Authors.AuthorID = TitleAuthor.AuthorID
Where YourCriteriaHere

Hope that helps!
 
Back
Top