top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to join 2 tables, without using any condition?

+2 votes
752 views
How to join 2 tables, without using any condition?
posted May 6, 2015 by Amit Sharma

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

1 Answer

0 votes

It is not possible to actually possible to join two tables without using any condition. If we would like to join two tables, then in source qualifier transformation add all the ports from two tables(if both tables are from same database source) and write down your join condition in user defined join option or otherwise write down join condition inside the sql query option with generated sql query.

OR simply use a dummy condition like 1=1.

answer May 7, 2015 by Manikandan J
Similar Questions
+2 votes

I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is located on Netezza.I tried writing SQL in SQL override to join all the tables but it throws me an error. Can someone help me how to resolve this issue?

Thank you.

+1 vote

I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is located on Netezza.I tried writing SQL in SQL override to join all the tables but it throws me an error. Can someone help me how to resolve this issue?

...