i have seen in LEFT JOIN RIGHT JOIN INNER JOIN SELF JOIN

Regarding joins what are the differences you observed in
oracle 9i and sql server?

Question Posted / uma

Answer Posted / uma

i have seen in
LEFT JOIN
RIGHT JOIN
INNER JOIN
SELF JOIN

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we connect to postgresql using sql developer?

484

What are the indexing methods?

570

Does truncate table reset auto increment?

524

Advantages and disadvantages of stored procedure?

576

what is normalization? : Sql dba

559

Can we use join in subquery?

564

Can triggers stop a dml statement from executing on a table?

612

Can you call pl/sql package functions from within a fast formula?

560

Is sql better than excel?

513

How do I view a view in sql?

502

what are the different type of normalization? : Sql dba

550

How do you use join?

522

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

541

What is the left table in sql?

515

Can I call a procedure inside a function?

544