On 2/20/2013 6:36 AM, e-mail mgbg25171 wrote:
SELECT i,o,n FROM ( SELECT alias_id i, (SELECT orig_itm FROM stmnts where ID = alias_id) o, (SELECT itm FROM std_itms where ID = std_id) n FROM (SELECT std_id, alias_id FROM alias_itms) )
This can be written simpler as select alias_id i, orig_itm o, std_itms.itm n from alias_itms join stmnts on (alias_id = stmnts.ID) join std_itms on (std_id = std_itms.ID); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users