nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Joining tables

padytom

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

Find more posts tagged with

Comments

rdpeterson

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

Vineet Joshi

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