SELECT
CASE
WHEN type = 'allocated' THEN car_no
ELSE (SELECT car_no FROM tbl_booked_car_details b2
WHERE b2.tbl_booking_details_primary_id = bd.tbl_booking_details_primary_id
AND b2.type = 'allocated'
ORDER BY allocation_from_date DESC
LIMIT 1)
END AS car_no,
car_no as served_car,
allocation_from_date,
allocation_to_date
FROM tbl_booked_car_details bd
ORDER BY car_no, allocation_from_date;
Comments
Post a Comment