How do I UPDATE from a SELECT in SQL command C#? : I need to update Book table and Stock table same time using single query.Because ISBN_No in Book table is equal to ISBN_No in stock table.I would like to know how to put following query inside of the sql command

    UPDATE
    Table_A
    SET
    Table_A.col1 = Table_B.col1,
    Table_A.col2 = Table_B.col2
    FROM
    Some_Table AS Table_A
    INNER JOIN Other_Table AS Table_B
        ON Table_A.id = Table_B.id
    WHERE
    Table_A.col3 = 'cool'

 
