SQL Tips

You can use a SQL statement in the FROM clause of a SQL statement. This is called a inline view. Oracle treats the data set that is returned from the inline view as if it were a table. SELECT a.NAME, a.office1_phone. FROM ps_dwhr_demo_addr a, (SELECT x.emplid. FROM ps_dwhr_job x. WHERE x.deptid = '831A' AND x.status_flg = 'C' AND x.job ... ................
................