Start Date:2021-03-16 00:00:01<br>End Date:2021-03-18 23:59:59<br>Short Codes : 'SA-IN', 'RBTD', 'RBTP', 'RCPOUT','SA-OUT','SHIP','DEC_IN','DEC_OUT'<BR>New Query : SELECT product_type_code, short_code, vendor_code, part_number, ran_or_order, serial_reference, associated_document_reference, date_created, txn_qty
	FROM transaction_history 
	WHERE date_created between '2021-03-16 00:00:01' and '2021-03-18 23:59:59' and short_code in ('SA-IN', 'RBTD', 'RBTP', 'RCPOUT','SA-OUT','SHIP','DEC_IN','DEC_OUT') 
	and vendor_code = 'YA003' and txn_qty <> 0 order by product_type_code<BR>No of Rows 0<BR>New Query : SELECT product_type_code, short_code, vendor_code, part_number, ran_or_order, serial_reference, associated_document_reference, date_created, txn_qty
	FROM transaction_history 
	WHERE date_created between '2021-03-16 00:00:01' and '2021-03-18 23:59:59' and short_code in ('SA-IN', 'RBTD', 'RBTP', 'RCPOUT','SA-OUT','SHIP','DEC_IN','DEC_OUT') 
	and vendor_code = 'YA007' and txn_qty <> 0 order by product_type_code<BR>No of Rows 0<BR>New Query : SELECT product_type_code, short_code, vendor_code, part_number, ran_or_order, serial_reference, associated_document_reference, date_created, txn_qty
	FROM transaction_history 
	WHERE date_created between '2021-03-16 00:00:01' and '2021-03-18 23:59:59' and short_code in ('SA-IN', 'RBTD', 'RBTP', 'RCPOUT','SA-OUT','SHIP','DEC_IN','DEC_OUT') 
	and vendor_code = 'YA009' and txn_qty <> 0 order by product_type_code<BR>No of Rows 0<BR>MySQL Closed <BR>