What are joins..how many types of joins are there?

Answer Posted / akn

In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join

Is This Answer Correct ?    73 Yes 40 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1662


What is the difference between a user and a schema in oracle?

550


What is an oracle user account?

562


How to drop a stored procedure in oracle?

578


Differentiate between function and procedure in oracle.

551






i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1799


Explain implicit cursor.

546


How to use "while" statements in oracle?

724


Explain about your project and its relation to the current job position you are applying to?

528


What is difference between truncate and delete?

549


How to update values in a table in oracle?

564


What is oracle open database communication (odbc)?

546


How to run queries on external tables?

556


Respected sir, Please send me technical questions related to oracle apps..

1367


Is oracle a relational database?

511