Update field in one table by looking it in second table.
Posted on 2009-05-15
Well there just one problem. the second table may have multiple entries. so consider table A
ROLLNUMBER ALIAS NAME
111 GM GAURAV
111 MAN GAURAV
111 GAU GAURAV
NOW I NEED TO UPDATE NAME IN TABLE A LOOKING IT UP IN TABLE B. INNER JOIN WILL GIVE ME 6 ENTRIES BUT I NEED JUST THE NAME SO AFTER UPDATE I SHOULD HAVE JUST 2 ROWS IN TABLE A.