DIR : /home/kozerus/public_html/ko_center/sql/sm4.sql

/home/kozerus/public_html/ko_center/sql

-- sm4.sql
-- ======

--	20121128_1215 jk	

	select planid, loadmode, cabnum, cablim, cab,cab1,cab2, sum(amps) samps
	from koplans
	where loadmode == ''
	group by planid, loadmode, cabnum,cablim, cab, cab1, cab2 
	order by planid, loadmode, cabnum,cablim, samps, cab, cab1, cab2
	;