Answer / sukhbir

View and Join : two different way to join 2 or more
database table.

Join should be used to join 2 or 3 table small size table ..
performance will reduce in case of join b/w two large
database table.

View are always better then join in terms of performance....

Answer / rupali

view is used to display only selected coloumns,it provides
restriction to display selected coloumns to the selected
user.
but in joins there nothin like restrictions,it is simple
join of two tables or more than two tables....

Answer / gireesh

view is just virtually Create table and perform a task.
join is combine(group) two or more tables based on
conditions to collect data

Answer / visweswara

view contains 5 number of types.
in database view is joins 2 or more tables,
joins also do same work.
join is nothing but a database view.
view is generate the code and gives the result of table.
but our own 'join code' not genrate any programe but we
write reqired code for it and there is no external code is
genrated. thatsway join is better than view.
so we used to 'join' for write report programs.

how to make split command reusable?

0 Answers  

---

what is naming conventions given for lock object and how you create the lock object

1 Answers   IBM,

---

How to Create an Interactive List based on the selection criteria specified for the customer number for displaying the customer information on the basic list, their corresponding order details on the secondary list. Plz specify the coding details. Regards, Rahul

1 Answers   TCS,

---

can any body tell what is idoc archieving and how to do that

3 Answers   Accenture,

---

What are field symbols and field groups.?

1 Answers  

---

difference between step loop and table control?Plz urgent..

3 Answers   Accenture, CSD Bangladesh,

---

1.why dont use top of page. wat is the use?

2 Answers  

---

how do you transport lsmw data from one system to another?

0 Answers  

---

By using which single table i can get all the detail from sale order to billing not used vbak, vbap, vbrk & vbrp.

2 Answers   Accenture,

---

hi this is naveenkumar.tell me plz. what is the difference between v4.7 and v4.6?

2 Answers  

---

Explain SD and MM Flow?

12 Answers   Keane India Ltd, Mascon, Tech Mahindra,

---

i can give default values in select-options also then what is use of INTIALIZATION event?

4 Answers   Wipro,

---