How To Join Pani Foundation : Let's look at a selection from the orders table then, we can create the following sql statement (that contains an inner join), that selects records that have matching values in both tables