The 10 tables can be joined as, select table1.columnname,table2.columnna

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

Question Posted / sathish

10 Answers
14751 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

Please Help Members By Posting Answers For Below Questions

Which command is used for user defined error messages?

1105

Explain concepts of analysis services?

1016

What are sparse columns?

1068

How we can compare two database data?

998

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1066

How adventureworkslt tables are related?

984

What is bcp? When does it used?

1044

What is raid, and how it can influence database performance?

1102

Can foreign key be duplicate?

1119

What is RMS migrations?

2192

Explain “not null constraint” in sql server?

1090

What does it mean to normalize data?

999

What is a cube? : sql server analysis services, ssas

1055

What are logical database components? : SQL Server Architecture

1095

How to enable tcp/ip protocol on a sql server?

1215