On 1/18/2013 11:10 PM, Kai Peters wrote:
these 2 queries
SELECT lm.ID, lm.Key1, lm.Key2, tr.ISOCode, lm.MaxChars, tr.Description as
Translation,
lm.Description
FROM LanguageMaster lm INNER JOIN Translations tr ON (tr.MasterID =
lm.ID) WHERE tr.ISOCode =
'DEU';
SELECT lm.ID, lm.Key1, lm.Key2, 'DEU', lm.MaxChars, '' as Translation,
lm.Description
FROM LanguageMaster lm WHERE lm.ID not in (SELECT MasterID from
Translations);
give me the data I want. Can they be combined into one?
SELECT lm.ID, lm.Key1, lm.Key2, coalesce(tr.ISOCode, 'DEU'), lm.MaxChars,
coalesce(tr.Description, '') as Translation, lm.Description
FROM LanguageMaster lm LEFT JOIN Translations tr
ON (tr.MasterID = lm.ID AND tr.ISOCode = 'DEU');
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users