我尝试了join,但不知道在这种情况下如何使用OR。
Table person
id name
1 Mark
2 David
3 Mike
4 Andrew
Table house
id city person
1 Moscow 1
2 Chicago 1
3 New York 2
4 Boston 2
Table car
id brand person
1 bmw 4
2 opel 4
3 toyota 2
4 volvo 2
结果应该是
name city car
Mark Moscow Chicago
David New York Boston toyota volvo
Andrew bmw opel