1

A result of two tables JOIN'ed is a cartesian product of the tables to which a filter is applied which selects only those rows with joining columns matching.

In the above sentence, which word does the modifier "to which a filter is applied" modify? a cartesian product or the tables or a cartesian product of the tables?

And again, which word does the modifier "which selects only those rows with joining columns matching" modify? a cartesian product or the tables or a cartesian product of the tables?

1 Answer 1

1

You have to look at the context to determine what nouns the modifiers are supposed to modify. In this case, the nouns and their modifiers are right next to each other:

Cartesian product of the tables --> to which a filter = filter of the tables

tables filter is applied --> which selects on those... = the filter selects...

The JOIN filter is being applied to both tables. Since "product" already implies that some operation has occurred, we can deduce that the filter was operating on the tables and that the product was the result. What is it filtering? Those rows with joining columns matching. Again, we can deduce that it is the filter that is selecting something, because that is the definition of a filter: selecting some but not all of a collection.

Admittedly, the sentence could be much clearer, e.g.,

A result of two tables JOIN'ed is a Cartesian product of the tables. The JOIN statement applies a filter to both tables and selects only those rows with joining columns matching.

5
  • 1
    Even if the modifiers are touching nouns, you still have to look at the context. This "rule" is not one that all native English speakers obey. May 2, 2014 at 3:34
  • @PeterShort Thanks, I revised my answer to reflect your feedback.
    – SEL
    May 2, 2014 at 3:40
  • Here is the original sentence. stackoverflow.com/questions/1018822/…
    – Jim
    May 2, 2014 at 3:42
  • 1
    Another question, is it grammatically possible that the clause "which selects only those rows with joining columns matching" modify the word "a cartesian product of the tables"?
    – Jim
    May 2, 2014 at 3:57
  • @Jim Grammatically, it's possible. But if you ever have to ask yourself what is being modified, chances are the sentence isn't clear writing.
    – SEL
    May 2, 2014 at 8:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.