On Tue, 15 Jan 2013 14:57:42 +0900, Yongil Jang wrote: > SELECT t1.key1, t1.key2, t2.description FROM MASTERLANGUAGES as t1, > MASTERLANGUAGES as t2 WHERE > t1.ISOCode = 'DEU' and t2.ISOCode = 'ENG' and t1.key1 = t2.key1 and t1.key2 = > t2.key2;
that is very close - just needed to add t1.description Thanks, Kai _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
