Hi This is my query,\[code\] SELECT tbl_order_detail.order_id, tbl_order_lead_send_detail.customer_id, tbl_order_detail.order_title, tbl_order_detail.dealer_id , tbl_order_lead_send_detail.send_date_time FROM tbl_order_detail INNER JOIN tbl_order_lead_send_detail ON tbl_order_detail.order_id=tbl_order_lead_send_detail.order_id where tbl_order_detail.order_status='Active' ORDER BY tbl_order_lead_send_detail.send_date_time DESC\[/code\]where I am getting the output as,
but, what I want is, to get only one data-row for one means distinct value of Order IDHow can I change my sql query to get my desired result.