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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
