How relation between one record on a table and several records on onother table
 
Clash Royale CLAN TAG #URR8PPP How relation between one record on a table and several records on onother table My project is a program like movie collection. Main table is for storing movie data with fields like name,director,release year  and ... But each record must have another attribute named genre (genres). Each movie may be categorized by one or several genres (Comedy, Horror, History, Romance,...) Genre table contain two fields.ID:integer and Genre:vchar For each movie, some of genre fields can be selected. How I can do this? thank you                             you have to use sql join  for that, but before this you have to set relationship of primary key table and foreign key table                     – ershoaib                 7 mins ago                                                                                     sql join                             Possible duplicate of How to implement one-to-one, one-to-many and many-to-many relationships while designing tables? Yo...