Bridge tables

I am trying to load a bridge table and having difficulty coming up with the logic to implement this. I did some research online but couldn't understand it. Can anyone provide a sample stub that can help me understand how do we usually implement this bridge table population(using listagg order by etc). I think a while back I was able to find a query online but lost the link unfortunately.