You can specify how you want the data from tables to be joined in many ways, one of which is the type of join. ... The major difference between inner and outer joins is that inner joins result in the intersection of two tables, whereas outer joins result in the union of two tables.