I am sorry, it is already solved. Finally I used the following syntax: UPDATE suppliers SET supplier_name =( SELECT customers.name FROM customers WHERE customers.customer_id =suppliers.supplier_id)
Which works perfectly, needless to say. It was due to my SQL knowledge ignorance. P. On Wed, Mar 4, 2009 at 1:31 PM, Brad Stiles <[email protected]> wrote: >> I am trying to do an UPDATE of one table based on the aggregate >> results of the different table. How can I do it in SQlite please? > > What have you tried that didn't work? > > /bs > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
