DELETE Statement won't work correct
SoftIl
softil at onlinehome.de
Wed Oct 27 19:37:05 CDT 2004
Hi,
what's wrong with this statement:
DELETE FROM behandlungsliste BHL, basisliste BL WHERE ((BL.betriebs_id =
'15427782-c133-11d8-a802-0010b53f93f1') AND (BHL.masterrec_id =
BL.record_id))
If I call this statement, all records in table "behandlungsliste" are
deleted.
I would like to delete in table "behandlungsliste" only the records for
which the condition is true?
How is the correct statement?
Thanks for your help
Carsten Ilwig
More information about the Valentina
mailing list