Joining tables

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


Comments

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


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


Sign In or Register to comment.