Ankita Kumari

Ankita Kumari

  • 2.1k
  • 79
  • 7.1k

data analysis query in mysql

Dec 27 2021 7:09 AM

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


Answers (1)