Updating two colums in diffirent tables.

[countdrak]

I am trying to update two seperate columns in two seperate tables. I am not quite sure if this is even possible, but I keep getting an error.

Code first.

UPDATE mfTableLines
SET	l.Time = 12,
	r.Status = 'C'
FROM mfTableLines l, mfTableRow r
WHERE l.item_no = '00230'
AND   l.lineID = r.LineID

Can I update two seperate columns like i have done above? I keep getting an "Cannot use the column prefix 'l'." IS there a diffirent syntax that I can use?

 

[fredericofonseca]

You need to issue ONE update statement for EACH table

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com