I'm trying to run a SQL query in a database to get the number of pieces, for each phase of position. I used the following query:
SELECT machine AS PLACED, AS PHASE phase, ACCOUNT (separate document) AS PARTIES FROM table1 JOIN LEFT table2 on table1.clear = table2.piece LEFT JOIN table3 on table2.bol = table3.bol O bol = = bol1 & # 39; AND convert (varchar, CONVERT (date, date, 106), 103)> = CAST (# 30 / 11/2018 AS AS DATE) AND convert (varchar, CONVERT (date, date, 106), 103) <= CAST (& # 39; 30 / 11/2018 & # 39; AS DATE) AND tabla1.pieza do not like '& # 39; GROUP BY PLACE, PHASE ORDER BY POST
and he returns the following:
I have repeated the narrative parts for each position and phase, while what I want is to see only the narrative of each phase.