MySQL query

[Anon]

Hello,

I need some help. I have three tables in a database. Say something like:

table 1 "articles"
article_name section_number author_number
"name one" 25 54
"name two" 68 54

table 2 "sections"
section_number section_name
25 "My section name"
68 "Section Name"

table 3 "authors"
author_number author_name
54 "Joe"
55 "Mike"

How can I compose a MySQL query so that based on the article_number, it would also select the section_name and the author_name.

Any help would be apreciated.

Andrey

[Anon]

SELECT sections.section_name, authors.author_name FROM articles, sections, authors WHERE articles.article_numner=123 AND articles.section_number = sections.section_name AND articles.author_number = authors.author_name;

this will return the author name and section name for article number 123.

hope that gets you going.

Daarius...