I searched for a while and I found Nothing. It looks like it is mandatory to use sentences like
UPDATE PROJECT
UPDATE PROJECT
SET DEPTNO = (SELECT WORKDEPT FROM EMPLOYEE WHERE PROJECT.RESPEMP = EMPLOYEE.EMPNO) WHERE RESPEMP='000030'
instead of using sentences with Join command :(
Note: If you find another way to do this, please let me know :)
References:
http://www2.systeminetwork.com/resources/clubtech/TNT400/bo400ng/sqlupdatejoin.htm
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AQ802/5.2
http://www.experts-exchange.com/Database/DB2/Q_22535124.html
1 comment:
Hello all,I am new and I would like to ask that what are the benefits of sql training, what all topics should be covered and it is kinda bothering me ... and has anyone studies from this course wiziq.com/course/125-comprehensive-introduction-to-sql of SQL tutorial online?? or tell me any other guidance...
would really appreciate help... and Also i would like to thank for all the information you are providing on sql.
Post a Comment