DB version:10gR2
Example from sample schema SCOTT
select e.ename, e.empno, d.loc
from
emp e inner join dept d on (e.deptno=d.deptno)
and e.ename like 'M%';
ENAME EMPNO LOC
---------- ---------- -------------
MARTIN 7654 CHICAGO
MILLER 7934 DALLAS
For every ename like 'MARTIN' the following two rows (hardcoded column values 001-985 and 003-745 ) should get created.
PAY_TYPES PAY_CODES
-------- ---------
001 985
003 745
Everything else must remain same.
The result set should look like the following. Here two rows got created for MARTIN and MILLER.Everything else remains the same
ENAME EMPNO PAY_TYPES PAY_CODES LOC
---------- ---------- -------- --------- -------------
MARTIN 7654 001 985 CHICAGO
MARTIN 7654 003 745 CHICAGO
MILLER 7934 001 985 DALLAS
MILLER 7934 003 745 DALLAS
How is this possible?