Hi I have 2 tables Table A and Table B I want to join these tables. The relation between these tables is RegNo The first table stores the Trudent details and second table is a history table The regNo in the first table is primary key and second table is forign key I want to Join all the data in the these two tables based on Date and Last updated time I want the result like the following pls help me to find a soln RegNo Name Class Date 12ABC ABC 10 3/2/2010 13ABC DCB 1 3/2/2010 14DFG DFG 12 3/2/2010 15FHG FHG 5 3/2/2010 16RTY RTY 8 3/3/2010 Table B Id RegNo LastUpdated 1 12ABC 3/2/2010 12:30 2 12ABC 3/2/2010 13:00 3 12ABC 3/2/2010 16:00 4 13BC 3/2/2010 12:00 Result RegNo Name Class LastUpdated 12ABC ABC 10 3/2/2010 16:00 13ABC DCB 1 3/2/2010 12:00 14DFG DFG 12 NULL 15FHG FHG 5 NULL

Hi, i have uploaded my sit to web server goddady.com i have a button to download dyanmically generated excel file.This button is ajax enabled.....When i am click on this button it will popup a message like "That assembly does not allow partially trusted callers" This is my web.config file Please help me on this issue?

Hi, i have uploaded my sit to web server goddady.com i have a button to download dyanmically generated excel file.This button is ajax enabled.....When i am click on this button it will popup a message like "That assembly does not allow partially trusted callers" This is my web.config file Please help me on this issue?