I have to display ten columns values from diffrent ten
tables.
how many joins are require?
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 database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
what does the automatic recovery do? : Sql server administration
what do you understand by change data capture?
How to list all login names on the ms sql server?
Explain what is meant by replication of database?
What is meant by datasource?
Explain log shipping?
How do I find the sql server database version?
What are the basic features of a trigger in ms sql server?
Can a database be shrunk with users active?
What is exporting and importing utility?
What is ms sql server service broker?
What are the system database in sql server 2008?
Explain stored procedure?
What are group functions in query statements in ms sql server?