Interested to Buy Any Domain ? << Click Here >> for more details...
I have to display ten columns values from diffrent ten
tables.
how many joins are require?
- 10 Answers
- 14409 Views
- CarrizalSoft Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / praveen mehta
There are 2 possible answers
1. No joins required
Ex:
SELECT Col1 As Col from Tab1
Union
SELECT Col2 As Col from Tab2
Union
SELECT Col1 As Col from Tab3
...
2. 9 Joins Required
Ex:
SELECT
t1.Col1,
t2.Col2,
....
FROM Tab1 t1
inner join Tab2 t2 on t1.Col1=t2.Col2
inner join Tab3 t3 on t1.Col1=t3.Col2
....
| Is This Answer Correct ? | 44 Yes | 2 No |
Post New Answer View All Answers
Write an sql query for deleting duplicate rows?
What stored by the master? : sql server database administration
Can binary strings be converted into numeric or float data types?
Relational calculus is what type of language?
How do I create a stored procedure in dbml?
What is postgresql server?
what are constraints? : Sql server database administration
What are the requirements for sql server 2016?
What is the difference between for trigger and after trigger?
What are the different acid properties?
Why is sql server log file full?
What is inner join in sql server joins?
How to fetch the next row from a cursor with a "fetch" statement?
How to write a query with a right outer join in ms sql server?
What is resource governor?
