Advertisement
Guest User

Untitled

a guest
Feb 21st, 2020
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. update isod.tbcase_act tbact
  2. set message_received_from =
  3. (
  4. select string_agg(concat_ws(' ', last_name, first_name, middle_name), ', ') from isod.tbcitizen
  5. where citizen_id in (select citizen_id from isod.tbmessage_received_from where act_id = tbact.act_id)
  6. )
  7. where act_id in (select act_id from isod.tbmessage_received_from);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement