2003, 2007


At the EOD, it appears that a WHERE clause accomplishes the same data set as an [INNER] Join.

What are the benefits of one over the other?


Also, it does not appear that the use of [ or ] preceding / following Table names and/or Field
names changes data set results.

Is the use of [ or ] a convention for reviewing code or are there substantive issues in some
end-use cases?

TIA EagleOne