join is combaining two or more tables. there are three types.they are 1).

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

Question Posted / guruswamy

Answer Posted / guruswamy

join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins

Is This Answer Correct ?

15 Yes

21 No

Please Help Members By Posting Answers For Below Questions

how do u setup a replication site?

2033

How to create tables for odbc connection testing?

1209

What is the Tune Query

2347

How do I reset a sequence in oracle?

1155

What to do if the startbd.bat failed to start the xe instance?

1129

What is a read write transaction in oracle?

1134

How to add a new column to an existing table in oracle?

1191

How to create additional tablespaces for an new database?

1079

Explain the blob datatype?

1125

How to invoke the data pump export utility?

1255

What do you mean by redo log file mirroring?

1071

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1129

What is a synonym? What are its various types?

1175

How view is different from a table?

1089

Give syntax for SQL and ORACLE joins.

1146