can someone rectify the code please

[tamilselvan]

 SELECT 
   consumer.FirstName,Consumer.LastName,
  Restaurant.Name,Restaurant.Type,
Reservation.ReservationDateTime ,
Consumer.ConsumerID 
FROM(Consumer INNER JOIN Reservation ON 
Consumer.ConsumerID = Reservation.ConsumerID)
INNER JOIN Restaurant ON 
Reservation.RestaurantID = Restaurant.RestaurantID
 WHERE ConsumerID = p_ID;

Is this working?

Tamil