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


Please Help Members By Posting Answers For Below Questions

How to change the data type of an existing column with "alter table" statements in ms sql server?

620


What is the main difference between ‘between’ and ‘in’ condition operators?

681


What is mscorsvw.exe - process - microsoft .net framework ngen?

611


What is the difference between web edition and business edition?

99


Detail about query optimizer?

701






What is primary key index?

627


Difference between report and query parameter.

695


What are the different types of replication are there in sql server 2000?

655


Explain acid?

695


How to use old values to define new values in update statements in ms sql server?

759


What is the difference between dropping a database and taking a database offline?

791


How do clustered indexes store data?

704


What are the database roles? : sql server security

647


what kind of lan types do you know? : Sql server database administration

604


Do you know what is blocking?

635