Click here to Skip to main content
15,867,771 members

Comments by Wendelius (Top 200 by date)

Wendelius 22-May-23 0:14am View    
I see that you removed the underscore but what about the actual question. Is the suggested subquery correlation what you're after?

WHERE pur.pro_id = sales.pro_id
Wendelius 14-May-23 11:52am View    
Try posting the original data in the table and an example what the query should return. Without this info there's not much we can do
Wendelius 16-Nov-22 23:20pm View    
What is the error you're referring to?
Wendelius 21-Aug-22 1:02am View    
What is the exact problem you're having, getting an error message or something else?
Wendelius 1-Jul-22 13:56pm View    
Earlier you wrote that the expected result is

I expect
cod_orc quantidade preco_unit iva totalciva1
16 1 1 23 1,23
47 1 1 23
47 1 1 23 2,46

If that's not the case can you post an example what is the expected result?