‎2007 Jul 20 11:20 AM
what is innerjoin & view? diff ..between them?
which one is advantage,explain plzzzzzzzzzz
‎2007 Jul 20 11:25 AM
Innerjoin and database view basically does the same. JOin two tables based on a condition.
The difference is that the VIEW is defined in a permanent fashion in the dictionary and the innerjoin's life is within the program. After the program, the join's existence will not be there.
Regards,
Ravi