i'm trying to get the summerized date from join query using aggregate function count() and left join [code] select Catagories.FieldId,Catagories.BookField, BookTitles.FieldId as"btitle" from Catagories left join BookTitle ...