SELECT * from dag_item where (flag ='2' OR flag ='3' or flag ='5' or flag ='6' ) and cancel='0' and invno IS NULL order by cuscode desc

#	JOB NO	SUPPLIER	HISTORY	MAKE	SIZE	WARRENTY	SERIAL NO	SELLING
1	8294	PERERA TYRE SERVICE		APOLLO	900*20	YES	TO337651813	0.00
2	8295	PERERA TYRE SERVICE		CEAT	700*16	YES	SC117384015	0.00
3	8301	PERERA TYRE SERVICE		CEAT	750*16	YES	SA053385020	0.00