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