Hi all, given
CREATE TABLE masterlanguages ( ID integer primary key autoincrement, Key1 varchar not null, Key2 varchar not null, ISOCode varchar not null, Description varchar not null, MaxChars integer default 0 ); insert into masterlanguages values (null, 'FORM1', 'SAVE_BUTTON', 'ENG', 'Save', 0); insert into masterlanguages values (null, 'FORM1', 'HELP_BUTTON', 'ENG', 'Help', 0); insert into masterlanguages values (null, 'FORM1', 'SAVE_BUTTON', 'DEU', 'Speichern', 0); insert into masterlanguages values (null, 'FORM1', 'HELP_BUTTON', 'DEU', 'Hilfe', 0); In addition to the data from SELECT * FROM MASTERLANGUAGES WHERE ISOCode = 'DEU' I also need the Description field for the corresponding record (based on Key1 + Key2) in English so that I can display the original English description as well as its German translation. How can I achieve this? TIA, Kai _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
