[Babase] ADM rnktype Query Changed in Babase

Karl O. Pinc kop at meme.com
Fri Oct 19 12:27:26 EDT 2007


On 10/18/2007 01:21:25 PM, Lacey Maryott wrote:
> Hello All,
> 
>    As Per out conference call yesterday regarding the errors in  
> rnktype queries, I have now changed the query for rnktype ADM to the  
> following
> 
> SELECT DISTINCT(biograph.sname) from biograph, members, rankdates  
> where biograph.sname = members.sname AND members.date >= %s AND  
> members.date<= %f AND members.grp= %g AND biograph.sex='M' and  
> rankdates.sname=biograph.sname and ranked <= %f;

For good form we want to qualify each column name with a table
name, so it should end with: rankdates.ranked <= %f

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list