x****y
发帖数: 252 | 1 电话面试，在这道题上栽了很多次。
what is outer join? what is different between inner join and outer join?
如果，是写SQL，没问题。但是，口述，就是闷葫芦--倒不出.
有没有谁给个标准答案？
"An outer join does not require each record in the two joined tables to have
a matching record. " --- From Wikipedia, the free encyclopedia
My answer"An outer join doesn't require that two join tables have a match
record." 这个答案被批。 |
c*****d
发帖数: 6045 | 2 你的回答不对
have
【在 x****y 的大作中提到】
: 电话面试，在这道题上栽了很多次。
: what is outer join? what is different between inner join and outer join?
: 如果，是写SQL，没问题。但是，口述，就是闷葫芦--倒不出.
: 有没有谁给个标准答案？
: "An outer join does not require each record in the two joined tables to have
: a matching record. " --- From Wikipedia, the free encyclopedia
: My answer"An outer join doesn't require that two join tables have a match
: record." 这个答案被批。
|
m**********2
发帖数: 2252 | 3 Outer joins are inclusive in nature. what specifically gets included depends
on which side of the join you have emphasized. A left outer join includes
all the information from the table on the left, and a right outer join
includes all the information from the table on the right.
哈哈，抄书滴。。。不知道行不行。。。
have
【在 x****y 的大作中提到】
: 电话面试，在这道题上栽了很多次。
: what is outer join? what is different between inner join and outer join?
: 如果，是写SQL，没问题。但是，口述，就是闷葫芦--倒不出.
: 有没有谁给个标准答案？
: "An outer join does not require each record in the two joined tables to have
: a matching record. " --- From Wikipedia, the free encyclopedia
: My answer"An outer join doesn't require that two join tables have a match
: record." 这个答案被批。
|
t*********i
发帖数: 217 | 4 a left outer join will return all records from left table and only such
records from right table which matches the join condition to the left table.
a right outer join...
Don't know if this works or not, my own words. |
B*****g
发帖数: 34098 | 5 举例是最好的回答
have
【在 x****y 的大作中提到】
: 电话面试，在这道题上栽了很多次。
: what is outer join? what is different between inner join and outer join?
: 如果，是写SQL，没问题。但是，口述，就是闷葫芦--倒不出.
: 有没有谁给个标准答案？
: "An outer join does not require each record in the two joined tables to have
: a matching record. " --- From Wikipedia, the free encyclopedia
: My answer"An outer join doesn't require that two join tables have a match
: record." 这个答案被批。
|
j*****n
发帖数: 1781 | |
B*****g
发帖数: 34098 | |
j*****n
发帖数: 1781 | 8 mm 永远是对的... :)
【在 B*****g 的大作中提到】
: 顶，所以学习DB，必须提前来本版蹲点。
|
x****y
发帖数: 252 | 9 蹲过点。
当时觉得，outer join 简单，没想到，用语言描述的时候，就不利索了。：（ |
