General information
Category:
Coding, syntax & commands
It is my understanding that the select subquery in parentheses on table1 would run once for every record selected in the outer select from table2. If that is in fact true, even though your alternative may be easier to code or more clear to read, it would be way less efficient (and therefore slower) than a join. By the way, the fact that Bret and I work together has nothing to do with it. Honest (as Bret slips me $5). I just wanted to mention that for you to consider.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only