I am trying to fetch record of a customer's latest transaction. The query I am trying is this:

```
SELECT 
  food_rate,
  ambiance_rate,
  service_rate,
  cost_rate 
FROM
  tbl_transaction t 
  INNER JOIN tbl_feedback f 
    ON t.fid = f.fid 
WHERE date_time IN 
  (SELECT 
    MAX(date_time) 
  WHERE c_id = 1)

```

The output will be a single row only. But it is giving syntax error.