/***************QUERY 1 *******************/

SELECT ZIPADD.ZIPID, JURISNAME, ZIPADD.ZIP
FROM JURISDICTION, ZIPADD
WHERE JURISDICTION.ZIPID=ZIPADD.ZIPID;

SQL>
SQL>    ZIPID	JURISNAME		ZIP
2	1201	LOS ANGELES DTN		90007
3	1202	LOS FELEX DTN		90008
4	1205	ANGELES DTN		90417

3 rows selected
SQL>


/*************QUERY 2 *******************/

SELECT PROPERTY.PROPID, PROPERTY.SOLD, devsearchresid, searchdate, developerid
FROM PROPERTY, DEVSEARCHRESULT
WHERE PROPERTY.PropID=DEVSEARCHRESULT.PropID
AND
PROPID IN
(SELECT PROPID FROM ENVSTAT
WHERE ContLevel ='H');

SQL>
SQL>	PROPERTY.PROPID  PROPERTY.SOLD  devsearchresid  searchdate  developerid
2	121210		 Y		101010		12-AUG-1998 121

1 row selected
SQL>

/*******************QUERY 3 *****************/

SELECT property.PropID, contaminant
from property, contaminants
where property.propid=contitem.propid
and where contitem.contitem=contaminants.contitem

SQL> property.propid	contaminant
2	121210		SULPHUR
3	121210		NAPTHA

2 rows selected
SQL>