Query a table for a match field based on next record and display both records

[tonydepo]

Hi, I have data as follows:

Date Category ProductID Time Millisecs TrxID Image A Image B 4/4/2022 A FFF 7:32:18 AM 0.538983 1122 ABC123 ABC123 4/4/2022 A FFF 7:32:20 AM 0.562924 1123 ABB123 ABB123 4/4/2022 A FFF 7:32:23 AM 0.346227 1124 ADD223 DDD333 4/4/2022 A FFF 7:32:25 AM 0.346227 1125 DDD333 ABS444 4/4/2022 A FFF 7:32:27 AM 0.072311 1126 ABS444 AJJ232

I would like to output to display if "Image B" is the same as Image A in the next record. This also has to be based on the same "Category" and "ProductID" within under 5 seconds.


Output Result:

Date	Category	ProductID	Time	Millisecs	TrxID	Image A	Image B
4/4/2022	A	FFF	7:32:23 AM	0.346227	1124	ADD223	DDD333
4/4/2022	A	FFF	7:32:25 AM	0.346227	1125	DDD333	ABS444
4/4/2022	A	FFF	7:32:27 AM	0.072311	1126	ABS444	AJJ232

Thank you for the help!!

[June7]

Use nested query to pull value from another row. Review http://allenbrowne.com/subquery-01.html#AnotherRecord