Fejl i sql.. Apache Derby
Jeg har den her query, som jeg skal være en prepared statement:Select choice.id, choice.choice_key, choicetext.id as textid, choicetext.trans_key, choicetext.text from (choice RIGHT OUTER JOIN choicetext on choicetext.choice_id = choice.id and choice.item_id = ?) where choicetext.language_id = ?
Men den melder den her fejl, når jeg prøver:
Column 'ITEM_ID' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'ITEM_ID' is not a column in the target table.
Kan i hjælpe med at få den omformuleret..?