Joining 2 Tables with a third as indicator - please help me

[humer]

I have 3 tables
-articles (aprox. 25.000 rows)
-corr (aprox. 400.000 rows)
-types (aprox. 4.000 rows)

I have to combine articles.id with types.idlink
corr holds the correlation between them artid and typeid

so if the type is given, I want to check out the matchid article-ids and select them out of article.

This should run with one single query under mysql 3.23.55

 

[vbkris]

can u give me the correlation between:
article and corr
corr and type tables?

Known is handfull, Unknown is worldfull

 

[sleipnir214]

It's a fairly simply join:

SELECT
*
from
type t, corr c, articles a
where
t.idlink = c.typeid and
c.artid = a.id and
t.<type column> = <your type value>

The first conjoin relates type to corr. The second relates coor to articles. The third constrains the return to only those records where the type is a specific value.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!