How do you Join?

[Perad]

Table 'term_taxonomy'

term_taxonomy_id|term_id|taxonomy|description|parent|count

 

Table 'terms'

term_id|name|slug|term_group

 

What I need to do is this..

 

SELECT term_taxonomy_id FROM term_taxonomy WHERE taxonomy='category' 

 

I then need to reference term_taxonomy_id with term_id to get the name.

 

How do I do this in a single query?

[kickstart]

Hi

 

Something like this

 

SELECT term_taxonomy.term_taxonomy_id, terms.name, terms.term_id

FROM terms

INNER JOIN term_taxonomy

ON terms.term_id = term_taxonomy.term_id

WHERE taxonomy='category'

 

All the best

 

Keith

[dreamwest]

Simplest join possible

 

$result = mysql_query("SELECT * FROM term_taxonomy AS a, terms as b WHERE a.term_id=b.term_id");

 

 

[fenway]

Yes-- except the comma operator is EVIL and should never, EVER be used.