Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT b.title, b.author, aq.budget_code, aq.budget_name
- FROM biblio b
- LEFT JOIN aqorders a
- USING (biblionumber)
- LEFT JOIN aqbudgets aq
- USING (budget_id)
- WHERE a.datereceived BETWEEN '2021-03-02'
- AND '2025-03-04' AND
- aq.budget_code LIKE concat('','%')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement