Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update isod.tbcase_act tbact
- set message_received_from =
- (
- select 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);
- --select last_name || ' ' || first_name || ' ' || middle_name || ', ' from isod.tbcitizen
- --where citizen_id in (select citizen_id from isod.tbmessage_received_from where act_id = 10);
- select string_agg(concat(last_name,' ',first_name,' ', middle_name), ', ') from isod.tbcitizen
- 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