mercredi 17 février 2016

Combine 2 tables into 1

How would I combine 2 tables into 1? Maybe using INNER JOIN? Please advise. Thank you.

For example, with the following db I just created:

Table 1

  +----------------------+
  | Places               |
  +----------------------+
  | Cupertino            |
  | BJ's Restaurant      |
  | Cupertino Inn        |
  | Outback Steakhouse   |
  +----------------------+ 

Table 2

  +----------------------+
  | Distant              |
  +----------------------+
  | 0.6 km               |
  | 1.3 km               |
  | 1.3 km               |
  | 1.1 km               |
  +----------------------+ 

Select syntax and combine this table output would be something like this:

+---------------------+---------+
| Places              | Distant |
+---------------------+---------+
| Cupertino           | 0.6 km  |
| BJ's Restaurant     | 1.3 km  |
| Cupertino Inn       | 1.3 km  |
| Outback Steakhouse  | 1.1 km  |
+---------------------+---------+ 

Aucun commentaire:

Enregistrer un commentaire