INNER JOIN is a keywords that selects records in both tables that have matching values.
Example
| ProductID | ProductName | CategoryID | Price |
|---|---|---|---|
| 1 | Chais | 1 | 18 |
| 2 | Chang | 1 | 19 |
| 3 | Aniseed Syrup | 2 | 10 |
| CategoryID | CategoryName | Description | |
| --- | --- | --- | |
| 1 | Beverages | Soft drinks, coffees, teas, beers, and ales | |
| 2 | Condiments | Sweet and savory sauces, relishes, spreads, and seasonings | |
| 3 | Confections | Desserts, candies, and sweet breads |