How can I make this inquiry?

Question

How can I make this inquiry?

Navigation

#1 by (0 votes)

0

I need to count the number of spreadsheets in a range in table A , and I require that only count the number of spreadsheets that are TIPO CORRECTIVO , which is find in table B , I have the following query but I get a result or number of spreadsheets that does not match the correct result.

SELECT COUNT(A.PLANILLA) FROM acta_entrega A, control_planillas B
WHERE A.PLANILLA BETWEEN 002801 AND 002900
AND B.TIPO = 'CORRECTIVO'

mysql sql query

asked by Anderviver 23.08.2017 в 14:40

source

1 answer

Offset-Bootstrap4 I need to execute a SQL query in LINQ to return a list of a Complex Type

score 0 · Accepted Answer

You need to relate the two tables by some related data

SELECT COUNT(A.PLANILLA) 
FROM acta_entrega A 
inner join control_planillas B ON A.CampoRelacionadoConPlantillas = B.CampoRelacionadoConEntrega
WHERE A.PLANILLA BETWEEN 002801 AND 002900
AND B.TIPO = 'CORRECTIVO'

In this query you should replace CampoRelacionadoConPlantillas and CampoRelacionadoConEntrega with the name of the fields that relate your tables