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.
How to get max data in query..............
Moderator: General Moderators
-
manojsemwal1
- Forum Contributor
- Posts: 217
- Joined: Mon Jun 29, 2009 4:13 am
- Location: India
-
manojsemwal1
- Forum Contributor
- Posts: 217
- Joined: Mon Jun 29, 2009 4:13 am
- Location: India
Re: How to get max data in query..............
anybody is there who can help me................ 