One more:
How will I count multiple column from same table?
For instance,
Library item can be borrowed under borrowing category of short loan and ordinary loan. How would I produce a list of all library item under that category. And output will be the name of category and total number of item.
So, I have the table name "Borrowing_catg". This are the four collumn: b_catg_id, Shortloan_id, ordinaryL_id and library_item.
|