without matching columns in two tables. how can you join
- 5 Answers
- 10451 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvp
by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / manjunath
Case 1 : If we want to join two tables we need matching column based on condition.
Case 2 : If we join two tables without column then go for union T/R
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ankit kansal
Its against the concept of Normalization to join two tables without PK and FK relationship. however if you try to join both tables then it will return you Cartesian product.
lets say your first of your table contains = 12 rows and
the other one also contains 12 rows then net output will be 144 rows.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sarthak
U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.
| Is This Answer Correct ? | 1 Yes | 4 No |
What is the default join that source qualifier provides?
What are the advantages of informatica?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Hi experts, can anyone tell how much we use plsql in real time
How to use pmcmd utility command?
How will you convert rows into columns or columns into rows
How many mapplets u have created? and what is the logic used
When you move from devel to prod how will you retain a variable
What is meant by query override?
Explain the features of connected and unconnected lookup.
How to list Top 10 salary, without using Rank Transmission?
What is source qualifier transformation?
Teradata 
