HI folks,

I have created a set of 6 tables, the three i am having a problem with are made up of a many-to-many relationship.

Table 1 = Article
Table 2 = Subject
Table 3 = Article/Subject

What i am trying to do is to output a list of all article names (Article) which are associated with a one specific subject held in (Article/Subject).

e.g.

A S
1, 2, 3 1
2, 4 2


Subject 1 thus has article 1, 2 and 3
Subject 2 has article 2, 4

I can manage to list the Article ID's from the (Article/Subject) table, but unable to join the Article table to produce the names(Article.ArticleNames).

Is there an SQL query which is going to help me get pass this point? Please advise