If Condition

[jteixeira]

I have this Query ---->Select Infofin_prod.maquinaid,nicname,Infofin_prod.idprod,NomeProd,StockFrom Infofin_prod INNER JOIN Maquina on maquina.maquinaid=Infofin_prod.maquinaid INNER JOIN Stockss on stockss.maquinaid=Infofin_prod.maquinaid INNER JOIN Produtos on produtos.idprod=Infofin_prod.idprodGroup by Infofin_prod.maquinaid,nicname,Infofin_prod.idprod,NomeProd,StockOrder by StockI Want print a message if the Stock = 0, but i don't know i do it with a if condition

[aspnetguy]

I deleted your other 2 posts. Do not ask the same questions more than once. Be patient.what database are you using? It makes different when getting into this type of sql programming.

[jteixeira]

Microsoft SQL Server Management STudio Express

[aspnetguy]

try this http://doc.ddart.net/mssql/sql70/ia-iz_4.htm

[jteixeira]

But this only do to return one value, if i try this to return more then a value it doesn't work

[aspnetguy]

post your code

[jteixeira]

if(select stock from Stockss Where stock=0)=0Begin Print 'erro'EndErro ---> Msg 512, Level 16, State 1, Line 1Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

[aspnetguy]

this part (select stock from Stockss Where stock=0) potentially can have more than 1 record so the you cannot compare it to asingle value.You are better off tryign to handle this in your server side code. You can loop through the returned records in SQL but it is messy and confusing.Just return the query and process the records with PHP or something.

[jteixeira]

How i do it? can you help me?