title: i made a many to many relationship between the following tables, have i done it right? secondly i want a join query for them
body: <p>i have many to many relationship between the following tables:<br></p>
  
  <pre><code>create table instructors
  (i_id int not null identity(1,1) primary key,
  i_name varchar(50), etc...)
  
  create table members
  (
  m_id int not null identity(1,1) primary key,
  m_name varchar(50, etc...))
  
  create table schedule
  (sch_id int not null identity(1,1) primary key,
  sch_session varchar(10))&lt;BR&gt;
  -- session is(morning, afternoon, evening)&lt;br&gt;
  </code></pre>
  
  <p>bellow is my junction table</p>
  
  <pre><code>create table Ins_Mem_Sch
  (ins_mem_sch_id int not null identity(1,1) primary key,
  i_id int not null foreign key references instructors(i_id),
  m_id int not null foreign key references members(m_id),
  sch_id int not null foreign key references schedules(sch_id)
  )
  </code></pre>
  
  <p>i want to know if what i have done so far is right, secondly i tried to join them by query, but i couldn't, maybe its because i haven't practiced joins for many to many relationship, i am not a perfect programmer, so i want a join query to get data from all tables. 
  I would appreciate your help.<br>
  regards,</p>