Update Statment - Help wanted

[moz2407]

Hi,

I am fairly new to SQL statements and where as i can perform retriving types of queries i have been stuck on an UPDATE one for weeks now; quite frankly its making me pull what little hair i have left out!

I was hoping that someone alot smarter than me would be able to help.

I am trying to update a feild on one table based on 2 critera; one from the same table and another from another table.

This is what i am trying to do in "pigeon" sql languge

Update assignment
set assignent_type = "X" where assignment type ='Y' and request.request_type = 'Z'

If anyone out there can help you will saving valuable hair folicles.

Many thanks

Morris

[saravanankm]

hi moz2407!

Update assignment
set assignent_type = "X" where assignment type ='Y'
and request.request_type = 'Z'

this is Error

try this qry

Update assignment
set assignent_type = "X" where assignment_type ='Y'
and request.request_type = 'Z'


thnaks
Captain

[Reshmi Jacob]

Hello Morris

From what I understood, I think that ASSIGNMENT & REQUEST are two tables.
In the SQL stmt you must have to link the two table. IF RKey is the link b/w two tables :-

Update assignment
set assignent_type = "X" where assignment_type ='Y'
and ASSIGNMENT.RKey IN (SELECT RKey from REQUEST where request.request_type = 'Z')

If you have two or more fields as key , you can replace RKey with
RKey1|| RKey2||RKey3, same order should be followed in the SELECT stmt.

Hope this will save Five - Six hairs on your head!!!!!!!!!!!!!

Regards
Reshmi