select distinct * from s_sheet where multiplier = '1' and programid <> '' select * from s_sheet where programid = and multiplier = '0'

MULTIPLIER	PROGRAM	PROGRAMID	PROGRAMSOURCE
#qry_chkdata.multiplier#	#qry_chkdata.program#	#qry_chkdata.programid#	#qry_chkdata.programsource#