Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
SQL query need to be debug
Summary:
Hi all,
The Query which I run is showing the field names and the data is not populating. please help me to debug the error.
Content (required):
Outer joins need to be added.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
WIth pay_roll as (SELECT
py.payroll_name,
pt.hr_term_id
FROM
pay_payroll_terms pt,
pay_assigned_payrolls_dn apd,
pay_all_payrolls_f py
WHERE 1=1
AND pt.payroll_term_id = apd.payroll_term_id
AND pt.payroll_term_id = apd.payroll_term_id
Tagged:
0