SELECT fld_customerid,concat(fld_fname,' ',fld_lname) as 'consumerName',fld_redemptionName,c.fld_brand,a.fld_points,fld_status,fld_email FROM tbl_customers_redemption a inner join tbl_customers b on b.fld_id=a.fld_customerid inner join tbl_redemption c on c.fld_id=a.fld_redemptionid where date(a.fld_cDate)=date_sub(curdate(), interval 1 day) order by fld_customerid