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