[sqlite] Can these 2 queries be combined into one?

[Kai Peters]

Hi,

given

CREATE TABLE languagemaster (
  ID          integer primary key autoincrement,
  Key1        varchar not null, 
  Key2        varchar not null,
  ISOCode     varchar not null,
  Description varchar not null


CREATE TABLE translations (
  ID          integer primary key autoincrement,
  MasterID    integer not null,
  ISOCode     varchar not null,
  Description varchar not null,
 --
  foreign key(MasterID) references languagemaster(ID)
);

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?

TIA,
Kai
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users