hello,
i have a problem that i just can't cope with.
the statement that works fine:
SELECT DetCats.id, title_de AS title FROM DetCats LEFT JOIN Details ON DetCat.id = Details.DCAT_ID WHERE Details.DCAT_ID is NULL
i get the ids of the values which are not used in table details.
now the next step would ideally be:
SELECT DetCats.id, title_de AS title, LANG_ID FROM DetCats LEFT JOIN Details ON DetCats.id = Details.DCAT_ID WHERE LANG_ID = 1 AND Details.DCAT_ID is NULL
i get no results, not even an error message.
the target is to get the ids which are not used in Details with this lang_id.
any hints?
thanks in advance
-anja
i have a problem that i just can't cope with.
the statement that works fine:
SELECT DetCats.id, title_de AS title FROM DetCats LEFT JOIN Details ON DetCat.id = Details.DCAT_ID WHERE Details.DCAT_ID is NULL
i get the ids of the values which are not used in table details.
now the next step would ideally be:
SELECT DetCats.id, title_de AS title, LANG_ID FROM DetCats LEFT JOIN Details ON DetCats.id = Details.DCAT_ID WHERE LANG_ID = 1 AND Details.DCAT_ID is NULL
i get no results, not even an error message.
the target is to get the ids which are not used in Details with this lang_id.
any hints?
thanks in advance
-anja