Inner joins to be used on the constrains(primary key/foregin key) on the table, when to extract information from the multiple tables.