Viewing 2 posts - 1 through 2 (of 2 total)
ramanathan.raman88 (2/2/2013)Table 1ABCDFA1B1NULLNULLNULLA2B2NULLNULLNULLA3B3NULLNULLNULLA4B4NULLNULLNULLA5B5NULLNULLNULLTable 2LocNameA1WhiteA2BlackA3RedA4OrangeA5BlueB1GreenB2YellowB3GoldB4RoseB5Silver
ramanathan.raman88 (2/2/2013)
ABCDF
A1B1NULLNULLNULL
A2B2NULLNULLNULL
A3B3NULLNULLNULL
A4B4NULLNULLNULL
A5B5NULLNULLNULL
Table 2
LocName
A1White
A2Black
A3Red
A4Orange
A5Blue
B1Green
B2Yellow
B3Gold
B4Rose
B5Silver
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