List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:June 27 2007 9:15am
Subject:Interresting update problem
View as plain text  
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
+45 40 85 71 38
+66 870 133 224



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

Thread
Interresting update problemMogens Melander27 Jun
  • Re: Interresting update problemDan Buettner27 Jun