How can we join the tables if they don't have primary and foreign key relationship and no matching port?

Answer 1

1.Add dummy ports in source tables
2.Assign '1' to each port
3.Join two tables (use join condition on common port)