This preview shows page 1. Sign up to view the full content.
Unformatted text preview: results. (V inner join PROJ1) union (V inner join PROJ2) select ENAME from V inner join PROJ1 on V.PNO=PROJ1.PNO where PNAME=”CAD” union select ENAME from V inner join PROJ2 on V.PNO=PROJ2.PNO where PNAME=”CAD” Since PROJ 2 doesn’t have any records where PNAME=“CAD” , the second join doesn’t return any records. Hence, the query becomes: select ENAME from V inner join PROJ1 on V.PNO=PROJ1.PNO where PNAME=”CAD”...
View Full Document
This note was uploaded on 12/23/2009 for the course DBST 663 taught by Professor Tba during the Spring '09 term at MD University College.
- Spring '09