On Fri, 2012-09-21 at 08:33 +0200, Giuseppe Costanzi wrote: > hi all, > could you check me the syntax of this statment? > > UPDATE batchs > SET > batchs.department_id = (SELECT > products.department_id > FROM products > WHERE > products.product_id = batchs.product_id) > > WHERE > EXISTS ( > SELECT * > FROM products > WHERE products.product_id = batchs.product_id > ) > > I would update the field named department_id on batchs table > with the values of the same field on products table. > the statement return > near ".": syntax error > but I don't see it. > Sql seems that don't digest the call to batchs.department_id > > regards > beppe
resolved UPDATE batchs SET department_id = (SELECT department_id FROM products WHERE products.product_id = batchs.product_id) > > _______________________________________________ > 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
