help...new to queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Private User - 22 Aug 2006 15:40 GMT

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

Reply to this Message

Jeff L - 22 Aug 2006 15:53 GMT

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!

> I want to write a simple query using the pubs database.
>
[quoted text clipped - 5 lines]
>
> thanks

Reply to this Message

Ofer Cohen - 22 Aug 2006 16:57 GMT

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

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

Signature

Good Luck
BS"D

> I want to write a simple query using the pubs database.
>
[quoted text clipped - 5 lines]
>
> thanks

Reply to this Message