everywhere a road intersects with another road and i want it to give me a table with all the roads plus all the names of roads they intersect.

Im trying to figure out everywhere a road intersects with another road and i want it to give me a table with all the roads plus all the names of roads they intersect.

I have major roads, and I want to know all the major and smaller roads that intersect each major road (this will be a non-spatial table)

I want my end user to select one road, and it will return all roads that crossed this major road's path.