[Babase] troublesome query

Susan Alberts alberts at duke.edu
Fri May 7 16:25:28 EDT 2010


Lacey and Karl,

Here is the query we were just talking about that took a long time to  
process.

select *
into alberts.gcounts
from actor_actees, biograph, maturedates
where actor_actees.actor = biograph.sname
and maturedates.sname = biograph.sname
and actor_actees.date > maturedates.matured
  and biograph.matgrp < 2.9
and biograph.sex = 'F'
and actor_actees.act = 'G'
------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC  
27708. Phone 919-660-7272, FAX 919-660-7293





More information about the Babase mailing list