dimanche 27 décembre 2015

SQLITE: How can I UPDATE using SELECT statement

If I have an sql statement like this:

SELECT ref_no, count FROM A WHERE ref_no = 1;

how can I UPDATE using the above statement ? something like:

UPDATE B SET count FROM (SELECT ref_no, count FROM A WHERE ref_no = 1) AS C

Aucun commentaire:

Enregistrer un commentaire