I have a selection query SELECT which when I apply a filter with WHERE no longer brings me anything but without the filter if it brings me all the data.
SELECT PC.ProductoCatalogoId, P.Nombre, PC.PrecioVenta, E.Nombre, O.NombreOpcion
FROM ProductoCatalogos AS PC
INNER JOIN Productos AS P
ON PC.ProductoId = P.ProductoId
INNER JOIN EspecificacionCatalogos AS EC
ON PC.ProductoCatalogoId = EC.ProductoCatalogoId
INNER JOIN EspecificacionProductos AS EP
ON EC.EspecificacionProductoId = EP.EspecificacionProductoId
INNER JOIN Especificaciones AS E
ON EP.EspecificacionId = E.EspecificacionId
INNER JOIN Opciones AS O
ON EC.OpcionId = O.OpcionId
WHERE PC.ProductoId = 7
ProductCatalog
Why when I put the WHERE does not filter?
Database diagram
