显示孪生对状态的表

每一次会面以一个称为event的状态码结束。下面显示的查询被用来显示按事件组合的所有孪生的表。这表明多少对孪生已经完成，多少对的其中之一已完成而另一个拒绝了，等等。 电脑软件www.boydavid.com

SELECT  

        t1.event,  

        t2.event,  

        COUNT(*)  

FROM  

        lentus AS t1, 电脑技术www.boydavid.com 

        lentus AS t2,  

        twin_project AS tp  

WHERE 电脑入门www.boydavid.com 

        /* We are looking at one pair at a time */  

        t1.id = tp.id  

        AND t1.tvab=tp.tvab  

        AND t1.id = t2.id  

        /* Just the screening survey */ 电脑学习网站www.boydavid.com 

        AND tp.survey_no = 5  

        /* This makes each pair only appear once */  

        AND t1.tvab='1' AND t2.tvab='2'  

GROUP BY  

        t1.event, t2.event; 

服务器租用/服务器托管中国五强！虚拟主机域名注册顶级提供商！15年品质保障！--亿恩科技[ENKJ.COM]