baran.f.a
پنج شنبه 11 دی 1393, 19:18 عصر
سلام می خواستم بدونم آیا کوئری زیر اشتباه؟
select pos.psp_id ,0 as `Raw` ,COUNT( change_location.serial_code) as `Cancell`,0 AS `repair`,max(change_location.update_date) ,pos.update
from change_location
INNER JOIN pos
on change_location.serial_code = pos.serial_code
where change_location.status='ابطالی'
and change_location.update_date > pos.update
and (change_location.terminal_code=pos.terminal_code)
group by pos.psp_id
select pos.psp_id ,0 as `Raw` ,COUNT( change_location.serial_code) as `Cancell`,0 AS `repair`,max(change_location.update_date) ,pos.update
from change_location
INNER JOIN pos
on change_location.serial_code = pos.serial_code
where change_location.status='ابطالی'
and change_location.update_date > pos.update
and (change_location.terminal_code=pos.terminal_code)
group by pos.psp_id