I need to check if a data in table1 is represented in table2
Na tabela1
ID | NOME | PARCELAS | DATA | NF
Na tabela2
ID | VALOR | PARCELA | VENCIMENTO | NF
SQL Query with INNER JOIN
I may be mistakenly wanting to query with inner join
what I need to know if the number of entries of tabela2
is actually the amount of parcels reported in column parcelas
of tabela1
, example if in% with% column tabela1
is reporting 3 I need to know if there are actually 3 releases in parcelas
.
The query I performed is 'but' is not bringing what I need.
SELECT *
FROM 'tabela2'
INNER JOIN tabela1 ON ftabela2.NF =
tabela1.NF
WHERE fin_lancamentos.Qtde_Parcelas > 1