I have to display ten columns values from diffrent ten
tables.
how many joins are require?

Answer Posted / srinu

No Join is required

Is This Answer Correct ?    13 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is user defined datatypes and when you should go for them?

597


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

646


what are cursors? : Sql server database administration

524


How to sort query output in descending order in ms sql server?

554


How to list all stored procedures in the current database using ms sql server?

646






Write a SQL queries on Self Join and Inner Join.

623


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

631


Explain what is the use of custom fields in report?

507


what is checksum in sql server.........???

1211


How to declare and use cursor variables?

594


What are the different acid properties?

635


Can we join two tables without primary key?

623


What are the parts of a function?

532


What is the impact on other user sessions when creating indexes?

550


Who is the owner of a schema in ms sql server?

556