New answers tagged

1

You have to define the aliases for the columns outside the subqueries: with d as ( select distinct emp.ahrims_id, rank.name as rank from hr_employee as emp, ana_rank as rank, unit_identification_code as uic, record_record as rec where emp.unit_identificatin_code_id = uic.id and rec.hr_employee_id = emp.id and rank.id = ...



Top 50 recent answers are included