|
View previous topic :: View next topic
|
| Author |
Message |
narasimharao_koganti
New User
Joined: 26 Apr 2005
Posts: 11
Location: pune
|
|
|
|
hi,
this has been asked me in the interview with L&T. can we update a table with join? i said no. if any body knows better answer. tell me. |
|
| Back to top |
|
 |
sankari_thiyaga
New User
Joined: 14 May 2005
Posts: 4
|
|
|
|
hi,
using SELECT statement with JOIN , only displaying the output in an output file is possible.
SELECT is for displaying only. u can't update a table with a select statement.
sankari. |
|
| Back to top |
|
|
sankari_thiyaga
New User
Joined: 14 May 2005
Posts: 4
|
|
|
|
hi,
I think that using update statement only one table can be updated .
am i right?
sankari. |
|
| Back to top |
|
|
apte.yogesh
New User
Joined: 27 May 2005
Posts: 1
|
|
|
|
| narasimharao_koganti wrote: |
hi,
this has been asked me in the interview with L&T. can we update a table with join? i said no. if any body knows better answer. tell me. |
hi friends,
no we can not use update clause with join.
actually there is no logic in this question cos , when u want to update some table why would u use join ? |
|
| Back to top |
|
|
eashwar
New User
Joined: 21 May 2005
Posts: 26
Location: Bangalore
|
|
|
|
| you can insert to a table using join also but i'm not sure if insert is considered as update or not |
|
| Back to top |
|
|
|
|
