1 statement to delete , update 2 tables [message #211619] |
Sat, 30 December 2006 00:25  |
josh_snehal
Messages: 15 Registered: May 2006 Location: BANGALORE
|
Junior Member |
|
|
Hi Buddy,
Wish you a Happy & prosporous New Year.
Have some interesting questions , if someone can answer with explanation that will be great.
1. Can we delete from 2 tables using single delete command ?
2. Can we update 2 tables at a time using 1 update statement ?
I guess answer for first is NO , but not sure if using In-Line Updatable views if this can be made possible.
Example queries if any can be of good help.
Thanks
Snehal
[Updated on: Sat, 30 December 2006 00:26] Report message to a moderator
|
|
|
|
|