Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
select pr.id, 
       pr.date_created, 
       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;

...