Page 1 of 1

How to get max data in query..............

Posted: Sat Feb 13, 2010 8:26 am
by manojsemwal1
hai i have a tabel called studentqualification and one table studentdetailtb .
when i insert the data in to the table the data has save both table education part saved in studentqualificationtb and student general information part save in studentdetailtb

my problem is that i want to fetch information from both table with student highest qualification...
studentqualification structure are like:

----------------------------------------
TempID class Year Universities Division
-----------------------------------------
ATC01 BCA 2006 HU 1st
ATC01 MCA 2009 HU 1st
--------------------------------------------
when the data will fetch it will take only highest Class like MCA and Year 2009.

Re: How to get max data in query..............

Posted: Mon Feb 15, 2010 5:22 am
by manojsemwal1
anybody is there who can help me................ :cry: