Re: HAVING query structured wrong

2019-02-19 Thread Chuck Martin
On Mon, Feb 18, 2019 at 12:37 PM Andrew Gierth wrote: > > "Chuck" == Chuck Martin writes: > > Chuck> I am trying to create a query that returns all transactions for > Chuck> each person who has a balance over a given amount. I thought > Chuck> HAVING was the answer, but if so, I'm mis-usi

Re: HAVING query structured wrong

2019-02-18 Thread Andrew Gierth
> "Chuck" == Chuck Martin writes: Chuck> I am trying to create a query that returns all transactions for Chuck> each person who has a balance over a given amount. I thought Chuck> HAVING was the answer, but if so, I'm mis-using it. This query Chuck> returns only transactions exceeding the

HAVING query structured wrong

2019-02-18 Thread Chuck Martin
I am trying to create a query that returns all transactions for each person who has a balance over a given amount. I thought HAVING was the answer, but if so, I'm mis-using it. This query returns only transactions exceeding the given amount rather than transactions for people whose balance is over