Problem with SQL query

-1 votes

1 answer

71 views

                          I have the following Problem: I want as output a specific document (TITLE) that contains two different terms (TERM). For example the title of a fairy tale, that contains the names of two different characters. And I have the following data structure (**bold=tables**, *italic=keys*):

**DOCUMENT** ( *DOCUMENT_ID*, TITLE )

**DOCUMENT TERM** ( *DOCUMENT ID*->DOCUMENT, *POSITION OF TOKEN IN DOCUMENT*, TERM,
TOKEN, POS ID->POS )

**POS** ( *POS ID*, LOW, HIGH, DESCRIPTION, LONG DESCRIPTION, PARENT POS->POS )

I tried the following solution, but it didn't work. I hope someone can help:

    SELECT
    	TITLE
    FROM
    	DOCUMENT
    WHERE 
    	DOCUMENT_ID
    IN (
    	SELECT
    		DOCUMENT_ID
    	FROM
    		DOCUMENT_TERM
    	WHERE
    		(TERM = 'Term1') AND (TERM = 'Term2')
    )


                        

Asked by ghillb (113 rep)

Oct 25, 2016, 11:39 AM
Last activity: Oct 25, 2016, 12:49 PM

Problem with SQL query

Related Questions