ello,
For the same problem that I posted which dated 2000-08-15
"Help with SQL [PHP and MySQL]".
Does anyone, has a high knowledge of INNER JOIN.
As I stated in my post that my SQL is not to good.
select m.material_id
from materials m
INNER JOIN (materialsKeywords mk (INNER JOIN keywords k
on (k.keyword_id = mk.keyword_id)))
where word = "central sulawesi" and word = "culture"
I have attempted the above SQL many times, just getting no where!
Any help would be most appreciated.
Annalise
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
For the same problem that I posted which dated 2000-08-15
"Help with SQL [PHP and MySQL]".
Does anyone, has a high knowledge of INNER JOIN.
As I stated in my post that my SQL is not to good.
select m.material_id
from materials m
INNER JOIN (materialsKeywords mk (INNER JOIN keywords k
on (k.keyword_id = mk.keyword_id)))
where word = "central sulawesi" and word = "culture"
I have attempted the above SQL many times, just getting no where!
Any help would be most appreciated.
Annalise
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->