‎07-06-2018 09:19 AM
‎07-11-2018 10:25 PM
Inner Join (Select Top 1000000 htblticketcustomfield.ticketid,
htblticketcustomfield.data
From htblticketcustomfield
Inner Join htblcustomfields On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Where htblcustomfields.name Like 'PCD-HDD ToteID Name') As ToteIDName
On htblticket.ticketid = ToteIDName.ticketid
Where htblcustomfields.name Like 'PCD-HDD ToteID Name'
As ToteIDName
ToteIDName.ticketid
ToteIDName.data As ToteIDName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now