Thanks for the help, problem solved. As for what I'm working on is a
program for a church to better keep track of the donations they receive.

Once again thanks,

Jankowiak


--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

>
> When using aggregate functions, you have to tell Firebird which fields
> it has to group by, in your case
>
> create view VIEW_COMMITMENTS_LEFT ( ID_MEMBER, ID_DONATION,
> TOTAL_MONTHS_PAID, MONTHS_COMMITED )
> as
> select
> donation_commitments.id_member,
> donation_commitments.id_donation,
> COUNT(commitments_paid.month_paid),
> donation_commitments.months_commited
> from
> donation_commitments
> join
> commitments_paid on
> commitments_paid.id_member = donation_commitments.id_member AND
> commitments_paid.id_donation = donation_commitments.id_donation
> where
> donation_commitments.done <> 1
> group by
> donation_commitments.id_member,
> donation_commitments.id_donation,
> donation_commitments.months_commited
>
> Alternatively, you could use group by 1, 2, 4
>
> All the best with your donations,
> Set
> -curious about what you are working with
>
> killerion wrote:
> > I'm trying to create the following view:
> >
> > create view VIEW_COMMITMENTS_LEFT ( ID_MEMBER, ID_DONATION,
> > TOTAL_MONTHS_PAID, MONTHS_COMMITED )
> > as
> > select
> > donation_commitments.id_member,
> > donation_commitments.id_donation,
> > COUNT(commitments_paid.month_paid),
> > donation_commitments.months_commited
> > from
> > donation_commitments,
> > commitments_paid
> > where
> > (commitments_paid.id_member = donation_commitments.id_member) AND
> > (commitments_paid.id_donation =

donation_commitments.id_donation) AND

> > (donation_commitments.done <> 1)
> >
> > I get the following error:
> > Invalid expression in the select list (not contained in either an
> > aggregate function or the GROUP BY clause).
> >
> > Now I assume this is due to the COUNT, since without it I can create
> > the view, now any suggestions on how to get this to work or is there
> > some other error I can't see?
> >
> > Jankowiak
>