电话面试,在这道题上栽了很多次。 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." 这个答案被批。
【在 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." 这个答案被批。
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." 这个答案被批。
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.
【在 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." 这个答案被批。