Databaser & SQLur Databashanterare & SQL
1 svar · 342 visningar · startad av phonkworks
Hej!
Får inte denna fråga att funka. Blir galen. Vad är fel?
select document.* , tags.* , categories.*
from document, tags, categories
INNER JOIN tag_article_map, category_article_map
on DOCID = TAMAPDOCID
and TAGID = TAMAPTAGID
and DOCID = CAMAPDOCID
and CATID = CAMAPCATID
where DOCID = 1234882322826
Mvh phonk
Felmeddelande?
Testa denna syntax:
select ... from document, tags, categories, tag_article_map, category_article_map where DOCID = TAMAPDOCID and ...
...eller
select document.* , tags.* , categories.*
from document inner join tags on ...
inner join categories on ...
inner join tag_article_map on ...
...