mysql delete query from 2 table

mysql delete query from 2 table :

 DELETE rbs_room_booking , rbs_sc_user  FROM rbs_room_booking  INNER JOIN rbs_sc_user WHERE rbs_room_booking.booking_id= rbs_sc_user.booking_id AND rbs_room_booking.booking_id = '310'