honar abubakr

honar abubakr

  • NA
  • 73
  • 110.6k

how to select data from two tables with join?

Aug 2 2013 11:14 AM
i have three tables

1- room_info  with four fields
field_name   data_type    description
----------   ----------    -----------
r_id              number      primary key
r_number       number
r_floor            text

1- student_info  with five fields
field_name   data_type    description
----------   ----------    -----------
s_id              number      primary key
s_name         text      
s_college       text
s_dept          text
r_id              number      foreign key

 3- como_info with five fields
field_name   data_type    description
----------   ----------    -----------
c_id              number      primary key
c_sys            number     
c_dosh          number     
c_dol             number     
r_id               number      foreign key

r_id from room_info is foreign key for both como_info and student_info
i want to make select query to select s_name,s_college,c_sys,c_dosh???
i use c# and access 2010

Answers (12)