What is a Join in SQL Server?
Answers were Sorted based on User's Feedback
Answer / guest
Join actually puts data from two or more tables into a
single result set.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / simran_8185@rediff.com
joins is one of the facility provided to retrieve the data
from one or more than one tables simultaneously bt there
should be data intergrity among those tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / radhakrishnan
Join:
we are develop the table based on normalization
concept.data stored different table based on constraint.
when we required data from multiple table we need to use
Join clause.
we can use one or more than table in join caluse.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of placing primary key and foreign key constrains on columns.
How sql server enhances scalability of the database system?
How to delete duplicate rows in sql server?
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
What is the use of for clause?
Are resultset updatable?
Get Current System Date Time
how you can move data or databases between servers and databases in sql server? : Sql server administration
What do you mean by authentication modes in sql server?
How do you optimize Sql queries ?
What is the difference between login and a user?
13 Answers CTS, TCS,
What is use of except clause? How it differs from not in clause?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)