Jump to content

BIRT Developer Center Download


Photo
- - - - -

Joining tables


  • Please log in to reply
2 replies to this topic

#1 padytom

padytom

    Advanced Member

  • Members
  • PipPipPip
  • 61 posts

Posted 08 October 2015 - 06:07 PM

Hi, trying to join workorder table to ticket table but at a lost as to which fields to join. any help?



#2 rdpeterson

rdpeterson

    Advanced Member

  • Members
  • PipPipPip
  • 48 posts

Posted 19 April 2016 - 12:29 PM

Did you try TICKET.ORIGRECORDID (where TICKET.ORIGRECORDCLASS = 'WORKORDER') = WORKORDER.WONUM?



#3 Vineet Joshi

Vineet Joshi

    Advanced Member

  • Members
  • PipPipPip
  • 88 posts

Posted 04 May 2016 - 05:34 AM

Select * from Maxrelationship where parent='WORKORDER'. This table has all the maximo table relationship