blah blah blah is here! blah blah » Close

0
saidan
69
393 views

using aggregate function with join query

up1down
link

i'm trying to get the summerized date from join query

using aggregate function count() and left join

select Catagories.FieldId,Catagories.BookField, BookTitles.FieldId as"btitle" from Catagories
left join
BookTitles
on BookTitles.FieldId=Catagories.FieldId


this code works fine
but when i use aggregate function 

select Catagories.FieldId,Catagories.BookField, count(BookTitles.FieldId) as"btitle" from Catagories
left join
BookTitles
on BookTitles.FieldId=Catagories.FieldId


the following error appears:

Column 'Catagories.FieldId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

add comment
last answered one year ago

1 answers

Sort:
up1down
tick
link

Try:

select Catagories.FieldId,Catagories.BookField, count(BookTitles.FieldId) as"btitle" from Catagories
left join
BookTitles
on BookTitles.FieldId=Catagories.FieldId
group by Catagories.FieldId ,Catagories.BookField

  • answered one year ago by:

    foamy
    2499
  • edited one year ago
(x)
saidan
69

Thanx Dear It worked fine :)

add comment
Feedback