...
Code Block |
---|
select pr.id,
pr.date_created,
pr.active_workflow,
pr.patron_hostlms_code patron_system,
pr.status_code dcb_status,
pr.local_request_status pickup_request_status,
pr.local_item_id borrower_item_id,
pr.local_item_status borrower_item_status,
pr.next_scheduled_poll next_poll,
sr.local_item_status lender_item_status,
sr.local_status lender_request_status
from patron_request pr,
supplier_request sr
where sr.patron_request_id = pr.id
order by date_created;
|
...