Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update isod.tbcase_act tbact
- set message_received_from =
- (
- select string_agg(concat_ws(' ', last_name, first_name, middle_name), ', ') from isod.tbcitizen
- where citizen_id in (select citizen_id from isod.tbmessage_received_from where act_id = tbact.act_id)
- )
- where act_id in (select act_id from isod.tbmessage_received_from);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement