Hi Nikolas,
Here is the query you can make use of
SELECT [acussfrm.report_no],
[acussfrm.datesubmision],
[acussfrm.complainee_name],
[acussfrm.complainee_surname],
[acussfrm.complainee_idnumber],
[acussfrm.complainee_tel],
[acussfrm.policynumber],
[acussfrm.claimnumber],
[acussfrm.typeofperson],
[secfrm.department_name],
[acussfrm.status_id],
[acussfrm.id]
FROM [accusationform] AS acussfrm,
[secondform] AS secfrm
WHERE [acussfrm.department_id] = [secfrm.department_id]
Hope this helps you a bit.
Regards,
RK