Viewing 2 posts - 1 through 2 (of 2 total)
ramanathan.raman88 (2/2/2013) Table 1 A B C D F A1 B1 NULL NULL NULL A2 B2 NULL NULL NULL A3 B3 NULL NULL NULL A4 B4 NULL NULL NULL A5 B5 NULL NULL NULL Table 2 Loc Name A1 White A2 Black A3 Red A4 Orange A5 Blue B1 Green B2 Yellow B3 Gold B4 Rose B5 Silver
ramanathan.raman88 (2/2/2013)
A B C D F
A1 B1 NULL NULL NULL
A2 B2 NULL NULL NULL
A3 B3 NULL NULL NULL
A4 B4 NULL NULL NULL
A5 B5 NULL NULL NULL
Table 2
Loc Name
A1 White
A2 Black
A3 Red
A4 Orange
A5 Blue
B1 Green
B2 Yellow
B3 Gold
B4 Rose
B5 Silver
So your just asking how to join the two tables..?
June 26, 2013 at 9:32 am
#1627624
polkadot (6/7/2013)
I've got to figure out whose games scores changed the least over time. I've created DDL to illustrate
create table gamescores
(gameNo varchar(20) not null,
player varchar (20) not null,
score int...
June 7, 2013 at 2:37 pm
#1622183