Mysql Inner join with OR condition?
===

I have 2 tables like below

    location_distance
    -------------------
    id	fromLocid	toLocid		distance
    1	   3		      5		70
    2	   6		      8		15
    3	   2		      4		63
    ...

    
    other_table
    --------------------
    Id	fromLocid	toLocid		otherdata
    12	   5		   3		xxxx
    22	   2		   4		xxxx	
    56	   8		   6		xxxx
    78	   3		   5		xxxx

I would like to retrieve the distance b/w the locations in other_table for each row. Here's what i've tried

    SELECT ot.*, ld.distance FROM other_table AS ot 
    	INNER JOIN location_distance ld ON ld.fromLocid = ot.fromLocid AND ld.toLocid = ot.toLocid

This doesnt return the rows if the locations values are vice versa. How can i rewrite the above query to produce expected result? Should i inlude **OR** condition on the join clause? like below?

    SELECT ot.*, ld.distance FROM other_table AS ot 
    	INNER JOIN location_distance ld ON (ld.fromLocid = ot.fromLocid OR ld.fromLocid = ot.toLocid) AND (ld.toLocid = ot.fromLocid OR ld.toLocid = ot.fromLocid)



    Result
    ----------
    Id	fromLocid	toLocid		otherdata	distance
    22	    2		   4		xxxx		63
    78	    3		   5		xxxx		70

    Expected Result should be
    ---------------------------
    Id	fromLocid	toLocid		otherdata	distance
    12	      5		    3		xxxx		70
    22	      2		    4		xxxx		63
    56	      8		    6		xxxx		15	
    78	      3		    5		xxxx		70