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

Do you know how to store and query spatial data?

780


What is data source view or dsv? : sql server analysis services, ssas

756


Explain what is the main purpose of having conversation group?

699


Explain “row_number()” in sql server with an example?

721


Why do you want to join software field as you have done your BE in Electronics?

1889






When columns are added to existing tables, what do they initially contain?

801


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

737


Difference between Logical Page and Physical Page in SSRS.

412


Why should we go for stored procedures? Why not direct queries?

748


What the different components in replication and what is their use?

714


What is the difference between online clustering and Offline clustering?

2120


What are sql server procedures?

733


What do you mean by cardinality?

653


What are the transaction properties?

735


What is the default sql server instance name?

755