Answer / amretha

For set operators the columns in the tables must be the same.Where as for Joins if one column is same its enough to join two or more tables.

Answer / jyoti

Set - Comparison is to be performed on Tables.
Join- Comparison is to performed on rows of tables.

Answer / pandarinath

joins project the data from more than one table vertically
based on common cloumns among the tables.
in case of set operators, its combine(merge) data horizantally, programer have to manage the correct logic and sence in the data. set operators uses for data presentation.

Answer / mahesh

suppose if we have joined two tables display the both table column names whatever we are giving and incase if we are use set operators columns not displyaed both tables.only first select query columns only displayed.

Answer / nitin

There is no such difference between JOINS and SET operators. You can get the same result by using JOIN or SET operator.

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

What are the parameters that we can pass through a stored procedure?

0 Answers  

How to drop a stored function?

0 Answers  

What is ordinary table in oracle?

0 Answers   MCN Solutions,

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

How to connect ms access to oracle servers?

0 Answers  

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

What are a collation and state the different types of collation sensitivity?

0 Answers  

Describe an oracle table?

0 Answers  

can we insert any row to dual table if i got the permission from DBA

5 Answers   HCL, Tesco,

What is instant client oracle?

0 Answers  

hai, when to use char and varchar2....?

2 Answers