中文参考手册--8.MySQL教程--8.7双胞胎项目的查询（实例）

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

在Analytikerna和Lentus，我们为一个大的研究项目工程一直在做系统和现场工作。这个项目是InstituteofEnvironmentalMedicineatKarolinskaInstitutetStockholm和theSectiononClinicalResearchinAgingandPsychologyattheUniversityofSouthernCalifornia的合作项目。

双胞胎研究的更多信息可在下列链接找到：

http://www.imm.ki.se/TWIN/TWINUKW.HTM

项目的后面部分是用一个用Perl和MySQL编写的web接口来管理。

每天晚上所有会谈的数据被移入一个MySQL。

下列查询用来决定谁进入项目的第二部分：

selectconcat(p1.id,p1.tvab)+0astvid,concat(p1.christian_name,"",p1.surname)asName,p1.postal_codeasCode,p1.cityasCity,pg.abrevasArea,if(td.participation="Aborted","A","")asA,p1.deadasdead1,l.eventasevent1,td.suspectastsuspect1,id.suspectasisuspect1,td.severeastsevere1,id.severeasisevere1,p2.deadasdead2,l2.eventasevent2,h2.nurseasnurse2,h2.doctorasdoctor2,td2.suspectastsuspect2,id2.suspectasisuspect2,td2.severeastsevere2,id2.severeasisevere2,l.finish_datefromtwin_projectastp/*ForTwin1*/leftjointwin_dataastdontp.id=td.idandtp.tvab=td.tvableftjoininformant_dataasidontp.id=id.idandtp.tvab=id.tvableftjoinharmonyashontp.id=h.idandtp.tvab=h.tvableftjoinlentusaslontp.id=l.idandtp.tvab=l.tvab/*ForTwin2*/leftjointwin_dataastd2onp2.id=td2.idandp2.tvab=td2.tvableftjoininformant_dataasid2onp2.id=id2.idandp2.tvab=id2.tvableftjoinharmonyash2onp2.id=h2.idandp2.tvab=h2.tvableftjoinlentusasl2onp2.id=l2.idandp2.tvab=l2.tvab,person_dataasp1,person_dataasp2,postal_groupsaspgwhere/*p1getsmaintwinandp2getshis/hertwin.*//*ptvabisafieldinvertedfromtvab*/p1.id=
 
 

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>