Page 1 of 1

Single row update from multiple table

PostPosted: Wed Sep 24, 2014 9:11 pm
by jvinoth
Hi can anyone please let me know how to prepare the update query for the below select

SELECT * FROM tableh H, tablef F, tabeo O
WHERE H.CODE = '01' AND H.CODE = F.CODE
AND H.CODE = O.CODE
AND F.STORE = '0420' AND F.STORE = O.STORE
AND H.NO = F.NO AND H.NO = O.NO
AND H.ITM = F.ITM AND H.ITM = O.ITM
AND H.SK = F.SK AND H.SK = O.SK
AND F.TYPE=’BP’
WITH UR;

I need to update F.TYPE alone.

Re: Single row update from multiple table

PostPosted: Thu Sep 25, 2014 3:43 am
by NicC
You should not be using * - you should specify the column names.

What do you want to update F.type with? And under what coditions? Your SELECT would appear to have no relevance.