[Babase] ADM rnktype Query Changed in Babase
Lacey Maryott
lacey.maryott at duke.edu
Fri Oct 19 14:44:45 EDT 2007
change made in babase :)
L
Karl O. Pinc wrote:
>
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
More information about the Babase
mailing list