pgsql_JoinRowSet1 |
code :pgsql_JoinRowSet1.txt |
With JoinRowSet you may perform SQL JOIN between RowSet objects when they are not connected to a data source |
|
Select emp.empno, emp.ename ,emp.job, dept.loc,dept.deptno from emp
, dept where emp.deptno = dept.deptno and dept.deptno = 30
|
Output |