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

What is the size of partition table?

1042

how to use like conditions? : Sql dba

1103

What is Difference Between Unique and Primary Key Constraints?

1101

Which table is left in left join?

1009

Can we create a trigger on view?

891

What is a record in a database?

1059

what is column? : Sql dba

1002

How do I save the results of sql query in a file?

972

What is the purpose of a sql?

973

What are three advantages to using sql?

1008

What is query execution plan in sql?

1184

What is t sql used for?

1010

How do you update f as m and m as f from the below table testtable?

1848

what is the difference between truncate and delete statement? : Transact sql

1058

Can we use pl sql in sql server?

1079