| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Cab | Date: | May 20 2003 2:59pm |
| Subject: | Update from table with multiple conditions. | ||
| View as plain text | |||
Hi there. I have data in a table, in the form of: Subject OT Count Toto 1 1 Toto 0 2 Titi 0 3 Tete 0 4 Tutu 1 5 I'd like to make an update where in this particular example, 'Toto' is updated, so that if 'select subject, OT' returns the OT=1, that I can update the remaining subjects 'Toto', so that their OT fields equal 1 and not 0. Is this possible? Cab
| Thread | ||
|---|---|---|
| • Update from table with multiple conditions. | Cab | 21 May |
| • Re: Update from table with multiple conditions. | toby - | 21 May |
