count the item when appearing more than once in the column

1

I have a query showing me all my stock. But I need to count just the items which appearing more than once in the column. I know I have to use group by and having count >1 statement but I don't know how to fit that into my query.
This is my query:

select
t1.lotnopre, t1.lotno, t2.locbin , t2.locstor , ((t2.locstock+t2.locqrstock)+(t2.locpicked+t2.locconsign))+t2.localloc , t1.lotqty , t1.account15_lot, t2.partno_alt

from livedb.mbc020 t2, livedb.mbc300 t1

where t1.account15_lot = '1 1 5' and t2."account15_alt"=t1."account15_lot" and t2."partno_alt"=t1."partno_lot" and t2."warehouse_alt"=t1."warehouse_lot" and t2."lotnopre_alt"=t1."lotnopre" and t2."lotno_alt"=t1."lotno"
and t1."lotnopre" <> ' '

group by t1.lotnopre, t1.lotno , t2.locbin , t2.locstor , ((t2.locstock+t2.locqrstock)+(t2.locpicked+t2.locconsign))+t2.localloc , t1.lotqty , t1.account15_lot, t2.partno_alt
having count(t1.lotno)>1
order by t1.lotno

The statement don't seems to work. It doesn't show me any information at all. I have tried in many ways fitting this into my query but I am new building the reports and don't really know what I am doing wrong.
I would appreciate any help.

2
  1. To get sensible answers you need to take the time to post consumable test data.
  1. Stop using the old JOIN systax.
SELECT ...
FROM livedb.mbc020 M020
	JOIN livedb.mbc300 M300
		ON M020.account15_alt = M300.account15_lot
			AND M020.partno_alt = M300.partno_lot
			AND M020.warehouse_alt = M300.warehouse_lot
			AND M020.lotnopre_alt = M300.lotnopre
			AND M020.lotno_alt = M300.lotno
WHERE M300.account15_lot = '1 1 5'
	AND M300."lotnopre" <> ' '
  1. So many columns in a GROUP BY looks suspect. You are asking for a COUNT of lotno within the group so it is not surprising no rows are returned. It is difficult to tell what you are trying to count without test data.