Dear friends, My table data's like that :-
Year Constituency PartyName Result **** ********** ********* ****** 1989 chennai aiadmk loss 1989 chennai dmk win 1990 adyar aiadmk win 1990 adyar congress loss 1991 chrompet aiadmk loss 1991 chrompet dmk win 1992 saidapet aiadmk loss 1992 saidapet dmk win 1993 guindy aiadmk loss 1993 guindy mdmk win I need the following result? *Scenario:-* In which Constituency *aiadmk and dmk contested in same Year and same Constituency* ? How to wrote the Query,Please help me... Year Constituency PartyName Result **** ********** ********* ****** 1989 chennai aiadmk loss 1989 chennai dmk win 1991 chrompet aiadmk loss 1991 chrompet dmk win 1992 saidapet aiadmk loss 1992 saidapet dmk win R regards, Sivaprabu Ganesan. ** <http://about.me/gsivaprabu> _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
