Question { HCL, 17351 }
what is the difference between joins and set operators.i am
always confusing with two,can u pls kindly help me .
Answer
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.