Diagnostic Bill collection

select *from tb_diagbillpay ,tb_doctor,tb_opdref where tb_diagbillpay.p_doc=tb_doctor.doc_id AND tb_diagbillpay.p_reference=tb_opdref.opdref_id AND pay_time >= '2026-06-11 00:00:00' AND pay_time <= '2026-06-11 23:59:59' ORDER BY `tb_diagbillpay`.`billpay_id` DESC

Bill No	Patient name	Contact	Test Cost	Collection charge	Discount	Final amt	status	Action