I have a question that may be simple, but I'm not very good at SQL and ended up emerging a need I need to settle via bank.
There are some records that I must change, however to find them I use 2 table filters, I will use Table A and Table B, the SELECT I do this:
SELECT * FROM A, B
WHERE A.FILIAL = B.FILIAL
AND A.FORNECEDOR = B.FORNECEDOR
AND A.DATAENTRADA > '31/12/2011'
AND A.DATAENTRADA < '01/01/2014'
AND B.CSTPIS = '53'
AND B.CSTCOFINS = '53'
AND B.VALORPIS > 0
AND B.VALORCOFINS > 0
AND A.CODESP = '27'
I tried to do this and did not work:
UPDATE A SET A.CODESP = (SELECT 0 FROM A, B
WHERE A.FILIAL = B.FILIAL
AND A.FORNECEDOR = B.FORNECEDOR
AND A.DATAENTRADA > '31/12/2011'
AND A.DATAENTRADA < '01/01/2014'
AND B.CSTPIS = '53'
AND B.CSTCOFINS = '53'
AND B.VALORPIS > 0
AND B.VALORCOFINS > 0
AND A.CODESP = '27')
Someone has the idea of ??how I can do this code.
Thanks for help.