pentaho design report error
we are taking employees,departments ,designations,but in every table "name" field type is mentioned there, while we join the tables three tables name field types is showing in sql but while applying these query in pentaho report design it's taking as distinct columns , but in sql it's working fine.please give me ideas.
Query is:-
select employees.employeeid, employees.name,designations.name,d.name from employees INNER JOIN designations ON employees.designation_id=designations.id INNER JOIN departments as d ON employees.department_id=d.id
Thanks,
Nilesh
Post new comment