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