Copy Below Code View As A Text File Show Text Only Show API Edit Code

                            
UPDATE table1 JOIN table2 
    ON table1.id = table2.id
SET table1.name = table2.name,
    table1.`desc` = table2.`desc`



UPDATE site_listing JOIN house_listing 
    ON site_listing.datafrom_id = house_listing.ID
SET site_listing.admin_status = house_listing.sts;



UPDATE site_listing JOIN dve_users ON site_listing.mem_id=dve_users.ID
SET site_listing.email=dve_users.Email WHERE dve_users.Email LIKE 'demo@demo%';