| Subject | Re: [firebird-support] Re: Trouble with BETWEEN operator |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-04-11T00:09:08Z |
At 02:35 AM 11/04/2008, ainpoissee wrote:
join TAB_B tb on tb.AID = r0.UID
group by 1
having count(tb.AID) BETWEEN 1 AND 10
./heLen
>And what is the recommended/most efficient way to achieve the query then?SELECT r0.UID, count(tb.AID) FROM TAB_A r0
join TAB_B tb on tb.AID = r0.UID
group by 1
having count(tb.AID) BETWEEN 1 AND 10
./heLen