Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
delete from claim_detail;
where claim_detail.line + claim_detail.claim_num;
in(select c2.line + c2.claim_num;
from claims02 c2;
where c2.line = claim_detail.line;
and c2.claim_num = claim_detail.claim_num)
This query gives me 'Operator/Operand mismatch' Since claim_num is of type character and
Line is of Type Integer. I was putting the data from these two tables in third table
called Pending_dtl for back up, this saved my day. It was easy to put the same data we wanted to delete,
into some other table first and then
DELETE FROM CLAIM_DETAIL where CLAIM_DETAIL.pid in(SELECT pid from;
pending_dtl)
will do the trick where pid is primary key. Thanks for your help. Still if some body knows, what can
remove the error message from the above query using + operator, his /her views are welcome.
so Like jim Nelson said "there cannot be a second table field involved in the WHERE that you expect
to be handled in synchronization with the first table. In other words the field of the second table will
stay on the same record throughout the operation" seems to be right here also.
Thanks to Jim,Nadia
Bharat
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement