Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeating groups and outer joins

Status
Not open for further replies.

haste

Programmer
Feb 27, 2005
96
GH
I have a repeating group-based on a select statement with a outer join. This is so it always displays a default value. I have linked a repeating frame to the group but when the group returns rows where the default values occur nothing is displayed in the frame.
The sql for the repeating groupis something close to this since am away from my machine.


select nvl(a.fp_amt,0), b.allw_code
from emp_allowance a, std_allowances b
where b.std_key = '1'
and a.allw_code (+) = b.std_allw_code
;

Its a payroll query,where by not all employees earn std allowance thus the need for an outer join. It returns the allowance values if present.

emp_allowance table
-------------------
emp_code
allw_code

std_allowances table
--------------
std_key
std_allw_code
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top