有两张table
表1− CUSTOMERS
table
+----+----------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 32 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 25 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 27 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
表2− ORDERS
table
+-----+---------------------+------
|OID | Age| CUSTOMER_ID | AMOUNT |
+-----+---------------------+------
| 102 | 22 | 3 | 3000 |
| 100 | 32 | 3 | 1500 |
| 101 | 25 | 2 | 1560 |
| 103 | 27 | 4 | 2060 |
+-----+---------------------+------
查询应该打印第一个表中的所有数据,并代替 AGE
应该打印出来 OID
前任:
输入 ID
:3
输出:
ID NAME OID ADDRESS SALARY
3 kaushik 100 Kota 2000.00
7条答案
按热度按时间deikduxw1#
您需要在主键和年龄列上加入,因为有多个记录。
wnrlj8wa2#
尝试
j0pj023g3#
像这样的?
gk7wooem4#
尝试使用左连接,
nzk0hqpo5#
只需将customer表“id”的主键与外键order表“customer\u id”连接起来
yrefmtwq6#
试试这个
enxuqcxy7#
试试这个。