Re: UPDATE .. JOIN? - Mailing list pgsql-general

From ledwabakg
Subject Re: UPDATE .. JOIN?
Date
Msg-id 1365693199198-5751790.post@n5.nabble.com
Whole thread Raw
In response to Re: UPDATE .. JOIN?  (ledwabakg <kgauledwaba7@gmail.com>)
List pgsql-general
Replace the tables on this query with your joined tables

Update service_reminderschedule srs
set reminder_sent = false
from (
        select ss.fk_man_service_id, ss.serviceschedule_id, v.vehicle_id
                from serviceschedule ss
                inner join manufactureservices ms
                on ms.man_service_id = ss.fk_man_service_id
                inner join vehicle_model vm
                on vm.model_id = ms.fk_vehicle_model_id
                inner join vehicle_info v
                on v.fk_vehicle_model_id = vm.model_id
                where ms.fk_vehicle_model_id = 1) ss
where ss.vehicle_id = srs.fk_vehicle_id
and srs.fk_serviceschedule_id = ss.serviceschedule_id and srs.date_sent is
null;



--
View this message in context: http://postgresql.1045698.n5.nabble.com/UPDATE-JOIN-tp1895125p5751790.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: ledwabakg
Date:
Subject: Re: UPDATE .. JOIN?
Next
From: Shaun Thomas
Date:
Subject: Re: Update