Help with a sql query

Question

I have the following query

select * from Properties 
join PPHL on PPHL.postcode = Properties.postcode
and PPHL.name = Properties.propertyname
and PPHL.id <> Properties.propertycode
where Properties.clientid = 1

I want to update all the Properties from the results of this query with the id from the PPHL table, does anyone know the correct sql I need to do this? I am running this on mysql 5.

a'r · Accepted Answer · 2011-03-14 17:48:56Z

2

The set clause goes after the table joins. See the MySQL documentation for UPDATE for syntax help.

UPDATE Properties 
    JOIN PPHL ON PPHL.postcode = Properties.postcode
             and PPHL.name = Properties.propertyname
             and PPHL.id <> Properties.propertycode

SET Properties.propertycode = PPNL.id
WHERE Properties.clientid = 1

answered Mar 14, 2011 at 17:48

a'r

37.2k7 gold badges68 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Help with a sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related