🎴 Flashcard Mode
SQL Server Database Administration
Card1 / 9
Mastered0
Review0
QuestionClick to flip
To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
AnswerClick to flip back
A
3
💡 Explanation:
To avoid a cartesian product when joining N tables in a query, a minimum of N - 1 join conditions must be specified in the WHERE clause. Therefore, joining four tables requires at least three join conditions to properly relate all records without generating redundant combinations.