ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Raja,
Your requirement can be dealt as the entire string present in table b should be kept in table a and the rest needs to be deleted.
The query which i have provided exactly gives the output you have provided in your prev posts... i have tested it too ...
and as you said the first 4 cols are keys for the table it should not deteriorate performance too ...
anyways good to hear that you have found an alternative ... |
|