update statement

[chinni_77]

Hello,

I've two tables:Handset, Stimterm.They have 1-1 relation.

Now, I want to do something like this:

UPDATE Handset,Stimterm set hs_delete = 1 and stim_delete = 1 where hs_id =1 and stim_id =1

What exactly I mean is, I'm trying to set the value 1 for the columns hs_delete which corresponds to the table Handset and stim_delete which corresponds to the table Stimterm.

Well, i hope i expressed clearly.

Could somebody pls tell me is it possible to write such statements?

If yes, how can i write it and if NO, what is the alternative.

Thanks in advance

[bastien]

UPDATE Handset,Stimterm set hs_delete = 1 and stim_delete = 1 where handset.hs_id = stimterm.stim_id and handset.hs_id=1

[chinni_77]

Thanks Bastien.yet to check if it is working.BTW, how abt with delete?

Like, i write "DELETE from Handset where hs_id = $id" for one table.

How abt with two??

DELETE from Handset, stimterm where........

(how to use the id fields now?)

Thanks a lot

[Lars_Berg]

Use separate queries (one for each table), within a transaction.

[chinni_77]

bastien, the query which you have given me is'nt working.This is the error😃ynamic SQL Error SQL error code = -104

Thanks any way