Вот таблица:
CREATE TABLE "T" (
`action_ID` INTEGER NOT NULL,
`prov_title` TEXT NOT NULL,
`track_no` TEXT NOT NULL
);
INSERT INTO `T` VALUES
(10001,'ProvA','#12345'),
(10001,'ProvB','AB123'),
(10001,'ProvC','R-0001'),
(10002,'ProvA','AC456'),
(10002,'ProvB','R-0002'),
(10002,'ProvC','#98765');
Вот запрос:
SELECT
A.action_ID,
A.track_no,
B.track_no,
C.track_no
FROM (SELECT * FROM T WHERE prov_title = "ProvA") AS A
JOIN (SELECT * FROM T WHERE prov_title = "ProvB") AS B
JOIN (SELECT * FROM T WHERE prov_title = "ProvC") AS C
ON A.action_ID = B.action_ID AND A.action_ID = C.action_ID;