need to compare each of the the Part Name under Ticket.Id 123456 if any of them are the same in Ticket.Id 345691 and in the Ticket table (in the same row as the Ticket.Id) the list of Part names also found in the succeeding Ticket.Id

Ticket Table

Ticket.Id Event time

123456 8-Jul

345691 9-Jul

Parts table

Ticket.Id Part Name

123456 PartName1

123456 PartName2

123456 PartName3

345691 PartName1

345691 PartName3