• Correct if you are looking for the below one

    The select is of a.* not b.*

    if this is one you are at...

    Delete the matched records from source table(Second) with First table

    and then Insert into Source table with all records from First Table..

    Avoid * and mention column names...

    Check the rowsize also( approximate mamory of single row, multiply with 1.5 million ..cross check your space)...