top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
2,035 views
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
posted May 11, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer May 12, 2015 by Shweta Singh
...