We have a Label called 'Mac Users' and we want to run a report to find all tickets that have been submitted by members of that Label. I am pretty new to SQL and am having trouble getting it set up.

1 Comment   [ + ] Show Comment

Comments

  • Try this.

    Select
    ORG1.HD_TICKET.TITLE,
    ORG1.HD_TICKET.OWNER_ID,
    ORG1.HD_TICKET.SUBMITTER_ID,
    ORG1.LABEL.NAME,
    ORG1.HD_QUEUE_SUBMITTER_LABEL_JT.HD_QUEUE_ID,
    ORG1.HD_QUEUE_SUBMITTER_LABEL_JT.LABEL_ID
    From
    ORG1.HD_TICKET,
    ORG1.LABEL Inner Join
    ORG1.HD_QUEUE_SUBMITTER_LABEL_JT On ORG1.HD_QUEUE_SUBMITTER_LABEL_JT.LABEL_ID
    = ORG1.LABEL.ID
    WHERE ORG1.LABEL.NAME = 'Mac Users'
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share