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

Reply via email to