多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?()

  • A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
  • B、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
  • C、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
  • D、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题