Posted by ibiza on 09/24/06 17:53

wow! It all works :P

many thanks!

Razvan Socol wrote:
> 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: Problem displaying extended ascii characters from sql server in html
• Prev in forum: Better way to use BETWEEN Begin and End Dates
• Thread view: Re: how to get this resultset...

[Reply to this message]