r1= select * from tbl where party_name =aiadmk r2= select * from tbl where party_name =dmk
select constituency from r1,r2 where r1.year=r2.year AND r1.constituency=r2.constituency On Tue, Jul 16, 2013 at 9:51 PM, Vijay Varadan <[email protected]> wrote: > Madan U Sreenivasan <madanus@...> writes: > > > You will have to do a group by constituency and year - leaving the rest > of > > the answer for you to figure out - let me know if you need more clues. > > Nicely done. Providing a pointer to research and find the answer, yet > leaving > the door open to seek additional help. > > This is an excellent example for our community to follow and flourish. > > Cheers, > Vijay > > > _______________________________________________ > ILUGC Mailing List: > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc > ILUGC Mailing List Guidelines: > http://ilugc.in/mailinglist-guidelines > -- With Regards 'All people smile in the same language'. Be Happy & keep Smiling :-) - MMI _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
