6 Jul
2023
6 Jul
'23
9:32 p.m.
Hello team, Im trying to create a sql query that will return a count of books that will have a datelastseen from a date picker and combine/add all books on loan for the particular itemtype. I have 2 different itemtypes and would like a count for each itemtype to include those with a datelastseen and all those onloan for the itemtype. Any ideas/help will really be appreciated. Warm regards James