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
- 14416 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 use of builtinadministrators group in sql server? : sql server security
Why would you use sql agent?
What are a scheduled jobs?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to find the second highest salary of an employee?
How optimize sql query with multiple joins in sql server?
How exceptions can be handled in sql server programming?
What is model database? : SQL Server Architecture
What is a trigger and types of a trigger?
What is the difference between clustered and non-clustered indexes in ms sql server?
What are the different Topologies in which Replication can be configured?
What is sub-query in sql server?
What is data source document?
How to loop through result set objects using odbc_fetch_row()?
What is difference between materialized view and view?
