Hi Guys,

Thanks for the replies, after a bit of playing about I finally got it to work as I needed. I used the below code.

<code>

SELECT a.accomname, a.availno - count(book_id) as...