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


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\",
\" companies\".\"comments\",
\"contact_information\".\"dateandtime\" ,
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\"},
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


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.