Simple update im sure

[saintedmunds]

Hi

Im sure this is easy but cant get my head around it.
I have one table which i woul like to update from its self ie.
StudentID SymbolsID EnglishTaker MathsTaker etc

I want to update the Takers from SymbolsID2 To SymbolsID3 where the StudentID is the same.

Do i Make any sense?

Cheers

 

[AlexCuse]

Where the StudentID is the same as what?

Do you have multiple rows for each StudentID?

Hope this help,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SQLBill]

I would help us if you would provide sample data and what results you would like to get.

-SQLBill

Posting advice: FAQ481-4875

 

[saintedmunds]

Hi Sorry


This should help

StudentID SymbolsID EnglishTaker ScienceTaker MathsTaker FrenchTaker HistoryTaker GeographyTaker LatinTaker
12 2 TSW Set 1 Jco Set 1
12 3
20 2 TSW Set 1 HCh Set 1 jco Set 1
20 3
26 2 TSW Set 1 HCh Set 1 Jco HBP Set 2
26 3

 

[gmmastros]

Make sure you have a backup of this database before you run this.

[COLOR=blue]Update[/color] A
[COLOR=blue]Set[/color]    A.EnglishTaker = B.EnglishTaker,
       A.ScienceTaker = B.ScienceTaker
[COLOR=blue]From[/color]   Student A
       [COLOR=blue]Inner[/color] [COLOR=blue]Join[/color] Student B
         [COLOR=blue]On[/color]  A.StudentId = B.StudentId
         And B.SymbolsId = 2
         And A.SymbolsId = 3

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom