SELECT b.batch_no, b.tran_date batch_date, b.created_on batch_created_date, b.approved_on approved_date, 
	pm.description project_description, pf.name float_name, IF(b.complete = 1, 'Yes', 'No') batch_complete	    
FROM 0_i_owe_you_batches b
    JOIN 0_projects_master pm 
         ON b.project_id = pm.project_id 
    JOIN 0_petty_cash_floats pf  
    	ON b.float_id = pf.id  
WHERE 1 = 1 
ORDER BY b.created_on

SELECT b.batch_no, b.tran_date batch_date, b.created_on batch_created_date, b.approved_on approved_date, 
	pm.description project_description, pf.name float_name, IF(b.complete = 1, 'Yes', 'No') batch_complete	    
FROM 0_i_owe_you_batches b
    JOIN 0_projects_master pm 
         ON b.project_id = pm.project_id 
    JOIN 0_petty_cash_floats pf  
    	ON b.float_id = pf.id  
WHERE 1 = 1 
ORDER BY b.approved_on 