INNER JOIN is not showing two rows in the table

Asked

Viewed 45 times

0

I am trying to make a query in sql INNER JOIN two rows of my table does not appear.

SELECT Rma.cod_rma,Rma.cliente_rma,Produto.Sku_prod,Produto.Nome_prod,  Rma.Serial_rma
FROM Rma
INNER JOIN Produto
ON Produto.Sku_prod = Rma.Sku_prod
sql
  • 1

    I don’t understand bulhufas of the problem

  • I am trying to make a query in sql

  • when I run table two rows does not appear

  • in my table has 22 lines and appears only 20 when I run the query

  • It may be that not all the records you are consulting have relationship, for this reason do not appear all records.

1 answer

1

Apparently these lines do not have the same value. In Inner Join it is shown only when there is the same Key in both tables: inserir a descrição da imagem aqui

  • even if I run only the table with select table skips two rows

  • Apparently, the error is here: ON Product.Sku_prod = Rma.Sku_prod Maybe the records are different

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.