Simple Query

[jteixeira]

Update Infofin_prodset precoprod=(dinheiroprod/vendasprod)where(Select Infofin_prod.maquinaid,nicname,vendasprod,dinheiroprod,precoprod          From Infofin_prod INNER JOIN Maquina on maquina.maquinaid=Infofin_prod.Maquinaid          Where(precoprod*vendasprod)<>dinheiroprod)*/

For some reson it doesn't work

[aspnetguy]

what error do you get?your where condition is probably returning more than 1 result which is not allowed.

[jteixeira]

Msg 102, Level 15, State 1, Line 5Incorrect syntax near '/'.

[aspnetguy]

are all 3 fields precoprod, dinheiroprod, and vendasprod a numberic datatype (ie INT)?

[jteixeira]

I find the error:

Update Infofin_prodset precoprod=(dinheiroprod/vendasprod)where(Select Infofin_prod.maquinaid,nicname,vendasprod,dinheiroprod,precoprodFrom Infofin_prod INNER JOIN Maquina on maquina.maquinaid=Infofin_prod.MaquinaidWhere(precoprod*vendasprod)<>dinheiroprod)  --->*/

I have to delete */ to query works