Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

Given two tables, t1 and t2, the join condition "t1.t2_id = t2.id" how do you get rows from t1 that have NO counterparts in t2?

EXCLUDING JOIN t2 ON t1.t2_id = t2.id
LEFT OUTER JOIN t2 ON t1.t2_id = t2.id
LEFT JOIN t2 ON t1.t2_id = t2.id WHERE t2.id IS NULL
JOIN t2 EXCLUDING t1.t2_id = t2.id
RIGHT JOIN t2 ON t1.t2_id = t2.id
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon