Join and Where用法(二)
)
(null)
5
Venus
Chengdu
(null)
(null)
(null)
6
Lobna
Shanghai
7
777777
7
(null)
(null)
(null)
8
888888
9
(null)
(null)
(null)
9
999999
9
(null)
(null)
(null)
5) select * from cid.orders, cid.persons where cid.orders.person_id = cid.persons.person_id;
ORDER_ID
BOOK_NUMBER
PERSON_ID
NAME
CITY
1
111111
1
1
Jhon
London
2
222222
1
1
Jhon
London
3
333333
2
2
Danny
New York
4
444444
2
2
Danny
New York
5
555555
3
3
Tom
Beijing
6
666666
4
4
Candy
Dalian