[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