SHOW:
|
|
- or go back to the newest paste.
| 1 | UPDATE CONTRIBUTETO | |
| 2 | SET FEES = FEES + FEES * 0.01 | |
| 3 | WHERE (PaperNum,RESEARCHER) ANY ( | |
| 4 | - | SELECT PaperNum,RESEARCHER |
| 4 | + | SELECT PaperNum,CONTRIBUTETO.RESEARCHER |
| 5 | FROM CONTRIBUTETO, RESEARCHER, PAPER | |
| 6 | - | WHERE CONTRIBUTETO.RESEARCHER = RESEARCHERID |
| 6 | + | WHERE CONTRIBUTETYPE = 'First' |
| 7 | AND CONTRIBUTETO.RESEARCHER = RESEARCHERID | |
| 8 | - | AND CONFERENCELOCATION != 'KSA' |
| 8 | + | |
| 9 | AND NOT CONFERENCELOCATION = 'KSA' | |
| 10 | AND AFFILIATION = 'Government'); |
