In order to get one row of data you need to create aggregate (ie SUM/MAX)derived fields for each column you want to retreive. From there you need to query on the fields that are unique in the education table/deduction table etc. Then turn on database grouping.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.