DELETE Statement won't work correct

[Ruslan Zasukhin]

On 10/27/04 8:37 PM, "SoftIl" <softil at onlinehome.de> wrote:

Hi Carsten,

> 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))

I am not sure that 1.x do support ALIAS OF TABLE in the DELETE command.
I am also not sure that this is by standard,

    DELETE FROM behandlungsliste BHL

Why you use it ?!

Aha!

You specify 2 tables

This is wrong. DELETE can work only on 1 table.


> 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?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------