Hi,
I have a problem and I was wondering if you could help me.
I have a road intersection table like this:
OdonymeIDIDRueIDINTNameCountIndex730350012611Robert, Rue20730350013121Roxanne, Rue21730350013132Roxanne, Rue20730350015142Thérèse, Rue21730350012092Rue Raymond32730350012653Robert, Rue20730350012963Rosaire, Rue21730350012974Rosaire, Rue20730350015184Thérèse, Rue21
I need to create a table of intersection combinations (IDINT). In other words, for each intersection id I want to know the possible intersection 2 streets at a time.
Ex:
IDINTIDRue (1)IDRue(2)112121234243249294239293
Someone would have any idea?
thanks