select query in three tables with join

Question

I have three tables in access 2010 (room_info, student_info, commodity_info)

1- room_info

room_id - autonumber - primary key
room_no - number
floor_no - text 
part_type - text
year_reserved - text

2- student_info

student_id - autonumber - primary key
student_name - text
college - text
dept - text
stage - text
card_id - number
mobile_No - number
room_id - number - foreign key

3- commodity_info

commodity_id - autonumber - primary key
chair - number
desk - number ..............
room_id - number - foreign key

I want to make a select query to select data from these three tables in c#?

Answer 1

INNER JOIN in MS-ACCESS

I won't provide you the complete C# code as that would be like spoon feeding.

select *
from ((room_info
inner join student_info on room_info.room_id =student_info.room_id)
inner join commodity_info on room_info.room_id =commodity_info.room_id)