Re: Fast Update

[Ferdie Palero]

Hi Peter,

Where I am wrong here, always inserting a row even it was existing.

INSERT INTO exclusive (lname,fname,mame,bname,address,city,state,zip)
SELECT a.lname,a.fname,a.mname,a.bname,a.address,a.city,a.state,a.zip
FROM exclusive a
LEFT JOIN exclusive_temp b ON b.lastname = a.lastname
AND b.fname = a.firstname
AND b.mname = a.mname
AND b.bname = a.bname
AND b.address = a.address
AND b.city = a.city
AND b.state = a.state
AND b.zip = a.zip
where a.fname is null;


Regards,
FPalero