top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

0 votes
1,600 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...