You need the selects in each = expression to replace the variables there. Something like this if I translated your query correctly.
UPDATE stmnts SET itm=(SELECT itm FROM std_itms where ID = std_id) where ID=(SELECT alias_id from alias_itms); -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of e-mail mgbg25171 Sent: Wednesday, February 20, 2013 6:46 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] got selected items ok but can't update using them Thanks Simon... Your's works a treat Re your question about my error Here's my query UPDATE stmnts SET itm=n where ID=i ( 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) ) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users