I have to display ten columns values from diffrent ten
tables.
how many joins are require?
- 10 Answers
- 13070 Views
- CarrizalSoft Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / sathish
The 10 tables can be joined as,
select table1.columnname,table2.columnname,.....
from table1,table2,.......
It displays 10 fields from 10 different tables.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is the default port for SQL Server over a firewall?
How to insert stored procedure result into temporary table?
Where is localdb stored?
What are data driven subscriptions?
how would you store your query in an SSRS report or a Database server?
What is 1nf normalization form?
How to create a Master database in SQL server ?
your distribution database is full what will u do
what is a correlated sub-query? : Sql server database administration
List out the differences between the clustered index and non-clustered index in sql server?
What happens when converting big values to integers?
What are the new scripting capabilities of ssms? : sql server management studio
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How you can add messages to the nt event log from within a stored procedure?
How to find which stored procedure is currently running in sql server?
