Hi friend,


table Articles;
table Authors;
table AuthorArticle;



SELECT STRAIGHT_JOIN ArticleTitle, Copyright,
CONCAT_WS(' ', AuthorFirstName, AuthorMiddleName, AuthorLastName) AS Author
FROM Articles AS b, AuthorArticle AS ab, Authors AS a
WHERE b.ArticleID=ab.ArticleID AND ab.AuthID=a.AuthID AND Copyright<1980
ORDER BY ArticleTitle;


-------------------------

Visit for more information.

http://www.roseindia.net/ejb/

Thanks