顯示孿生對(duì)狀態(tài)的表

每一次會(huì)面以一個(gè)稱為event的狀態(tài)碼結(jié)束。下面顯示的查詢被用來(lái)顯示按事件組合的所有孿生的表。這表明多少對(duì)孿生已經(jīng)完成，多少對(duì)的其中之一已完成而另一個(gè)拒絕了，等等。 電腦軟件www.boydavid.com

SELECT  

        t1.event,  

        t2.event,  

        COUNT(*)  

FROM  

        lentus AS t1, 電腦技術(shù)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 */ 電腦學(xué)習(xí)網(wǎng)站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; 

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]