Infomaker reports SQL

  • Posted:
  • Proposals: 6
  • Remote
  • #42063
  • Archived
Ashish M.Feroz W.Alex K.Peyman A.SQL M. + 1 other have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Hi there,
I have created a report in Infomaker and it uses basic sql scripting.
Basically I am trying to join 3 tables into this report - people, currentemployment and companies I can link the people to currentemployment by people_guid and then currentemployment to companies by companies_guid but my problem is trying to add it to the below script. I am trying to get the column companies.comments out.
SELECT \"assignments\".\"title\",
\"assignments\".\"assign_no\",
\"assignments\".\"consultants\",
\"companies\".\"name\",
\"people\".\"firstname\",
\"people\".\"people_guid\",
\"assignments_people\".\"progress\",
\" companies\".\"comments\",
\"people\".\"current_company\",
\"people\".\"DOB\",
\"calendar\".\"summary\",
\"calendar\".\"description\",
\"people\".\"curemptitle\",
\"people\".\"lastname\",
\"assignments\".\"ref_number\",
\"contact_information\".\"dateandtime\" ,
\"contact_information\".\"createby\"
FROM {oj \"assignments_people\" LEFT OUTER JOIN \"contact_information\" ON \"assignments_people\".\"people_guid\" = \"contact_information\".\"people_guid\" AND \"assignments_people\".\"assignments_guid\" = \"contact_information\".\"assignments_guid\" AND \"assignments_people\".\"dateandtime\" = \"contact_information\".\"dateandtime\" LEFT OUTER JOIN \"calendar\" ON \"contact_information\".\"cal_entry_guid\" = \"calendar\".\"cal_guid\"},
\"assignments\",
\"companies\",
\"people\"
WHERE ( \"assignments\".\"client_company_guid\" = \"companies\".\"companies_guid\" ) and
( \"assignments\".\"assignments_guid\" = \"assignments_people\".\"assignments_guid\" ) and
( \"assignments_people\".\"people_guid\" = \"people\".\"people_guid\" ) and
( ( \"assignments\".\"assignments_guid\" in ( :a_guid ) ) )

If this is something you can help with please contact me.

Many Thanks

Rob

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.