[SeregaK]

SELECT TJ.new_spstage,InStepTable.New_stepnumber as StepNumber,COUNT(*) as InForThisStep,(SELECT COUNT(*) FROM (SELECT * FROM FilteredNew_TransactionJournal as CRMAF_FilteredNew_TransactionJournal) as TJOut
INNER JOIN FilteredNew_stepofvoronka as OutStepTable
ON (OutStepTable.New_Name=TJOut.new_spstage)AND(OutStepTable.New_voronka_step=TJOut.new_crater_stage)
WHERE
(TJOut.new_action=1)
AND
(TJOut.new_crater_stagename=@vorname)
AND
(OutStepTable.New_stepnumber=InStepTable.New_stepnumber-1)
)as OutFromBeforeStep
FROM (SELECT * FROM FilteredNew_TransactionJournal as CRMAF_FilteredNew_TransactionJournal) as TJ
INNER JOIN FilteredNew_stepofvoronka as InStepTable
ON (InStepTable.New_Name=TJ.new_spstage)AND(InStepTable.New_voronka_step=TJ.new_crater_stage)
WHERE
(TJ.new_action=0)
AND
(TJ.new_crater_stagename=@vorname)
AND
(TJ.new_spstage!='Потенциальное предложение')
AND
(InStepTable.New_stepnumber!=1)
Group by TJ.new_spstage,InStepTable.New_stepnumber
ORDER BY InStepTable.New_stepnumber