[Babase] Finding intergroup interactions
Karl O. Pinc
kop at meme.com
Mon Apr 19 10:58:24 EDT 2010
-- Warning condition
-- Interactions should be between individuals in the same supergroup.
SELECT interact.iid, interact.act, interact.date
, actor.sname, supergroup(actorgrp.gid, interact.date) as
actorsu\
pergroup
, actee.sname, supergroup(acteegrp.gid, interact.date) as
acteesu\
pergroup
, 'Warning: Interactions should be between individuals in the
sam\
e supergroup'
FROM interact, parts AS actor, parts AS actee
, members AS acteembr, members AS actormbr
, groups AS acteegrp, groups AS actorgrp
WHERE actor.iid = interact.iid
AND actor.role = 'bb_actor'
AND actormbr.date = interact.date
AND actormbr.sname = actor.sname
AND actorgrp.gid = actormbr.grp
AND actee.iid = interact.iid
AND actee.role = 'bb_actee'
AND acteembr.date = interact.date
AND acteembr.sname = actee.sname
AND acteegrp.gid = acteembr.grp
AND supergroup(actorgrp.gid, interact.date)
!= supergroup(acteegrp.gid, interact.date)
ORDER BY interact.date, interact.act, interact.iid, actor.sname,
actee\
.sname;
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