I am working for a pdf report and its sql builder.
My sql requirement is to add the existing field records to table 1 from table 2 where they have common fields as employee name
I initially tried the following sql builder
The problem is that when I ran the pdf or sql reports it appears several names/records of the same employee causing the pdf report not to function due to large number of pages. It multiply the same employee information, where I expect that it will provide only 1 page per employee.
Following are my requirement to appear or if I ran the sql, by adding existing column field information from 2 tables.
Column1 Column2 Column3
employeename (from table1) sales (from table1) commision(from table2)