I have to display ten columns values from diffrent ten
tables.
how many joins are require?
Answer Posted / ask
Select column1, column2, ...., column10 from table1,
table2, ..., table10
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Name few of the dcl commands in sql?
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? : Sql server administration
What are the steps to process a single select statement?
What are translations and its use? : sql server analysis services, ssas
What is the difference between executequery () and executeupdate ()?
Tell me what is use of except clause? How it differs from not in clause?
What is the default order of an order by clause?
What is the datatype of rowid?
What are the database roles? : sql server security
What are diverse clauses that form a part of sql?
How to check if a table is being used in sql server?
What are sp_configure commands and set commands?
What is cached report?
What are various ways to enhance the ssrs report?
How to include text values in sql statements?