Creating one table from multiple tables

Hi Team,

I have four tables called Acc, Lan, Conect and Contact

In Connect table has ID coloum which includes Lan ID and Acc ID records in that specific column. And Con ID coloum that can make a relationship with Contact ID coloum on Contact table

I want to create a table to show Acc Name, Lan and Contact ID but the issue is as the Acc ID and Lan ID is in the same coloum in Connect table I won't be able to get the data in table rows as attached image.

I need to show "eng and sin" in 3rd row as Con ID is the same for both the rows. Can you please let me know how I can do that.