SELECT a.transaction_id TRANSACTION_ID, count(*) SEGMENT_COUNT FROM ies_trans_segments a, ies_transactions b WHERE a.transaction_id = b.transaction_id AND b.status = 1 GROUP BY a.transaction_id
View Text - HTML Formatted
SELECT A.TRANSACTION_ID TRANSACTION_ID , COUNT(*) SEGMENT_COUNT FROM IES_TRANS_SEGMENTS A , IES_TRANSACTIONS B WHERE A.TRANSACTION_ID = B.TRANSACTION_ID AND B.STATUS = 1 GROUP BY A.TRANSACTION_ID