|
| DANH SÁCH KHÁCH HÀNG THEO LỊCH HẸN |
|---|
| | |
|---|
Không tạo được danh sách!
Lỗi: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by songay asc, ngaytieptheo asc' at line 8select dmdvnhan.tendvnhan,ngaysinh,diachi as diachi_kh,sodienthoai as sodienthoai_kh,dmdvnhan_dichvu.mavaccin,ngaydichvu,left(lichhen,10) as ngaytieptheo,
muithu,datediff(left(lichhen,10),20250623) as songay,
dmvaccin.tenvaccin
from dmdvnhan_dichvu
left join dmdvnhan on dmdvnhan_dichvu.madvnhan=dmdvnhan.madvnhan
left join dmvaccin on dmdvnhan_dichvu.mavaccin=dmvaccin.mavaccin
where date_format(left(lichhen,10),'%Y%m%d')>='20250623' and dmdvnhan_dichvu.userid=
order by songay asc, ngaytieptheo asc