How to write a join sql query for following conditions.
Posted on 2010-11-25
Txnenrollment contains familyid,enrolled,cardsprinted,personalized,pcode,blockcode.
Txnissuance contains those familyid which will be there in txnenrollment
and will have status enrolled=1 and personalized=1 and cardsprinted=1
mstpanchayat will contain pcode and pname
mstblock will contain blockcode and blockname
I want to list blockname,pname and count of total enrolled,total personalized and total cardsprinted with a check where all familyid should exist in txnissuance.