Thanks! That was it.
Drew
On Jun 6, 2007, at 1:45 AM, Ragnar wrote:
On þri, 2007-06-05 at 23:55 -0700, Drew wrote:
I'm having troubles using multiple OUTER JOINs, which I think I want
to use to solve my problem.
My problem is to find all non-translated string values in our
translations datab
Drew wrote:
This seems to me the appropriate situation for using OUTER JOINs, but I
cannot figure out how to get the null rows without the not-null rows.
However, when I try to exclude the one not-null row, doing this:
SELECT
s.source_id,tp.translation_pair_id,t.translation_id,t.language_i
On þri, 2007-06-05 at 23:55 -0700, Drew wrote:
> I'm having troubles using multiple OUTER JOINs, which I think I want
> to use to solve my problem.
>
> My problem is to find all non-translated string values in our
> translations database, given the 4 following tables:
>
> SOURCE (source_id PR
I'm having troubles using multiple OUTER JOINs, which I think I want
to use to solve my problem.
My problem is to find all non-translated string values in our
translations database, given the 4 following tables:
SOURCE (source_id PRIMARY KEY, language_id, value, ...)
TRANSLATION (translatio
