SQL Problem

From: David <david_at_davie.com>
Date: Thu, 15 Jul 2004 23:55:57 +0800
Message-ID: <40f6a90e$1_1_at_rain.i-cable.com>

Table A
Name Score
A 12
A 22
A 88
B 34
B 12
C 33
C 55

Table B

Name Score
A 12
NuLL 22
Null 88
B 34
Null 12
C 33
NUll 55

How can i create table b base on table a ? Received on Thu Jul 15 2004 - 17:55:57 CEST