Hi all,

I have mytable with 2 fields ( Name1 and Name2 ) and want to get Newtable
with 1 field called Name3:

blank and blank2 are fixed.

if Name1 = blank then Name3 must = ccccc

if Name1 = aaaaa then Name3 must = aaaaa

if Name1 = blank then Name3 must = blank and not blank2

...............

mytable

Name1:    Name2:

aaaaa    bbbbb
blank    ccccc
blank    blank2
ddddd    eeeee
fffff    ggggg
blank    hhhhh

Newtable 

Name3:

aaaaa
ccccc
blank
ddddd
fffff
hhhhh

How to do this with SQL ?

TIA