Posted by Razvan Socol on 09/24/06 05:45

Try the following (untested):

SELECT kanji_id FROM Kanji
WHERE kanji_id NOT IN (
SELECT kref_idkanji FROM KanjiRefs
WHERE kref_idref=3
)

SELECT kanji_id, (
SELECT kref_value FROM KanjiRefs
WHERE kref_idref=3
AND kref_idkanji=kanji_id
) as kref_value
FROM Kanji

Razvan

• Next in forum: ODBC: Call Failed
• Prev in forum: how to get this resultset...
• Thread view: Re: how to get this resultset...

[Reply to this message]