A.select e.ename，a.street_address，a.city，a.state，a.post_code from emp e outer join addr a on e.empno =a.empno where a.state =‘TEXAS’；
B.select e.ename，a.street_address，a.city，a.state，a.post_code from emp e left outer join addr a on e.empno =a.empno where a.state =‘TEXAS’；
C.select e.ename，a.street_address，a.city，a.state，a.post_code from emp e right outer join addr a on e.empno =a.empno where a.state =‘TEXAS’；
D.select e.ename，a.street_address，a.city，a.state，a.post_code from emp e right outer join addr a where e.empno =a.empno（+）and a.state =‘TEXAS’；