myles@... wrote:

> FROM
> SOUND
> INNER JOIN SOUND_STORAGE ON (SOUND.SOUND_NO = SOUND_STORAGE.SOUND_NO)
> ---
> What's really strange is that it works fine 99.9% of the time. But with
> certain data in the tables, it doesn't find it. But if I run the exact same
> query manually it works just fine.

What is the data type of SOUND.SOUND_NO and SOUND_STORAGE.SOUND_NO? Are
those the same?


--
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org