myParent.iid t1.pid t2.pid t3.pid t4.pid ------------ ------ ------ ------ ------ 1 1 2 1 1 2 1 3 5 2 3 1 3 5 3 4 2 4 7 4 5 4 7 6 6 4 6 7 8 9 * Desired output pid Cnt1 Cnt2 Cnt3 Cnt4 --- ---- ---- ---- ---- 1 3 1 1 2 1 1 1 3 2 1 4 2 1 1 5 2 6 2 7 2 8 9Any idea how I could do this just with one SQL ? TIA