Hi frnds....
i have to convert this query. So please lead me, or help me out.....
SELECT sum(Qty), Sum(round(errprice * Qty,2)) as 'Price' FROM ViewNoSale where tx_number=-1 and First_Name = 'Girish' and canceltime between '2015-12-10 00:00:00' and '2015-12-10 23:59:59' and date_format(Canceltime,'%m-%d-%Y %h:%i:%p') IN (select date_format(NSTime,'%m-%d-%Y %h:%i:%p') from nosale, tx_err_log where tx_err_log.userid=User_id and tx_err_log.registerno=reg_no and NSTime between '2015-12-10 00:00:00' and '2015-12-10 23:59:59')
Thnaks.....