Actualy i think thats exactly what im looking for (: Thank you Razzak, that oughta do the trick
----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 13, 2003 4:48 PM Subject: [RBASE-L] - RE: count with multiple tables > > Alan, > > How about "Creating Virtual Auto-Number in Views" and then > use the select criteria as you wish. > > Take a look at the technical article on Creating Virtual > Auto-Number in Views. > > From The Edge: Creating Virtual Auto-Number in Views > > http://www.razzak.com.fte (08/03/2000) > > Hope you find it helpful! > > Very Best R:egards, > > Razzak. > > At 04:25 PM 10/13/2003 -0700, Alan Wolfe wrote: > > >Nope I didnt know that, it sounds pretty useful though (: > > > >----- Original Message ----- > >From: "A. Razzak Memon" <[EMAIL PROTECTED]> > >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > >Sent: Monday, October 13, 2003 4:18 PM > >Subject: [RBASE-L] - RE: count with multiple tables > > > > > Alan, > > > > > > Did you know that using the R:BASE 7.0 for Windows Report > > > Designer, you can actually deploy the report on the web > > > as HTML with the Page xx of xx and have users navigate > > > through automatically generated report pages with icons, > > > etc. > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > > > > > At 04:07 PM 10/13/2003 -0700, Alan Wolfe wrote: > > > > > > >Hey Troy, > > > > > > > >Im actualy looking for blocks of 10, like if the user requests page 2 > > > >i want count >10 and count <=20 to show the results 11-20. > > > > > > > >if they request page 3 it would show count >20 and count <=30 to show > > > >results 21-30. > > > > > > > >----- Original Message ----- > > > >From: <mailto:[EMAIL PROTECTED]>Troy Sosamon > > > >To: <mailto:[EMAIL PROTECTED]>RBASE-L Mailing List > > > >Sent: Monday, October 13, 2003 3:55 PM > > > >Subject: [RBASE-L] - RE: count with multiple tables > > > > > > > >I think this would give you unpredictable results. > > > >I think you might be looking for a group by and a having clause. > > > > > > > >select table1.masterId, count (*) from table1 left join table2 on (....) > > > >group by table1.masterID having count (*) <= 10 > > > > > > > >This would give you a list of masterid with 10 or fewer rows in table2. > > > > > > > >Troy > > > > > > > > > > > > -----Original Message----- > > > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alan Wolfe > > > >Sent: Monday, October 13, 2003 3:54 PM > > > >To: RBASE-L Mailing List > > > >Subject: [RBASE-L] - count with multiple tables > > > > > > > >hello i was wondering about using count in selects that involve multiple > > > >tables. > > > > > > > >if i have something like this: > > > > > > > >select * from > > > >table1 left join table2 > > > >on (clause here) > > > >and count > 0 > > > >and count <= 10 > > > > > > > >which table does it get the count from? > > > > > > > >is it table1, table2 or is it the number of results that it returns? > > > > > > > >TIA, > > > >Alan > > > >
