On Fri, 18 Jan 2013 23:18:31 -0500, Igor Tandetnik wrote: > 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');
Thanks - so much better than just unioning them! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
