Advertisement
EntropyStarRover

koha sql acquisition by budget

Mar 4th, 2025
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. SELECT b.title, b.author, aq.budget_code, aq.budget_name
  2. FROM biblio b
  3. LEFT JOIN aqorders a
  4. USING (biblionumber)
  5. LEFT JOIN aqbudgets aq
  6. USING (budget_id)
  7. WHERE a.datereceived BETWEEN '2021-03-02'
  8.           AND '2025-03-04' AND
  9.           aq.budget_code LIKE concat('','%')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement