data analysis query in mysql

we have 4 tables 1. payments 2.booking_item 3.deals 4.product.

i have to join payment and booking_item tables on the basis of booking_id which is present in booking_item and payments table. ten we get the fields (product_id, deal_id and booking_id ) from booking_items table then we have to get deals table data using deal_id which is present in booking_item table and id in deals table. now we need prouct table data usind product id which is present in booking_item table and id in product table