Advertisement
Guest User

Untitled

a guest
Feb 21st, 2020
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. update isod.tbcase_act tbact
  2. set message_received_from =
  3. (
  4. select 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);
  8.  
  9. --select last_name || ' ' || first_name || ' ' || middle_name || ', ' from isod.tbcitizen
  10. --where citizen_id in (select citizen_id from isod.tbmessage_received_from where act_id = 10);
  11.  
  12. select string_agg(concat(last_name,' ',first_name,' ', middle_name), ', ') from isod.tbcitizen
  13. where citizen_id in (select citizen_id from isod.tbmessage_received_from where act_id = 10);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement