Interresting update problem

[Mogens Melander]

Hi all,

I'm trying to wrap my brain around folowing problem.

table main(code, field_1, field_2, field_3, , , field_51)

111, 'X', '', 'X',,,
222, '',  '', 'X',,,
333, '', 'X', '' ,,,
444, '',  '', '' ,,,
555, 'X','X', '' ,,,

table map(id, field)

1, 'field_1'
5, 'field_2'
9, 'field_3'
....
....
86, 'field_51'

The exercise is: replace 'X' with map.id in main.<map.field>

main.code and map.id are primary keys, all other are varchar.

Hmm, did that make any sense?

-- 
Later

Mogens Melander
[phone]
[phone]



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.