1 month ago

fetching data from a pivot table and link it with a column of another table

Posted 1 month ago by raviSoni

Hello everyone Basically my tables structure are

  1. Hotels [id,hotel_name,hotel_types] (Main Table)
  2. venue_themes [id,name] (Main Table)
  3. hotel_venues [id,hotel_id,venue_themes_id] (pivot table)

the hotel_types column is linked to my view and the main reason for creating pivot table is in the hotel_types we can store only a single value but we need more then one value for hotel_types column

what i want

a single hotel may have multiple venue themes

Thanks in advance

Please sign in or create an account to participate in this conversation.