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
