Hello, I am looking for a table in the db containing a pdf file with payslips. I need to know how to match it to the company and employee.
Userlevel 6
+8
Hi
Please try the below query:
SELECT a.lu_name, a.doc_no, key_ref, file_data
FROM doc_reference_object_tab a, edm_file_storage_tab b
WHERE a.doc_class = b.doc_class
AND a.doc_no = b.doc_no
AND a.doc_rev = b.doc_rev
AND a.doc_sheet = b.doc_sheet;
Best Regards,
Charitha
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.