>Hi, again...
>
>After reading the paragraph in the Hacker's Guide again, I think maybe I understand...I initially read it that you couldn't have a JOIN and a WHERE clause in the same SQL statement, which would be pretty limiting. After I read it again, I (think) I realize what it's saying...that you can't do joins between different tables both in a JOIN as well as a WHERE in the same SQL statement...which still wouldn't limit you from doing the other stuff you'd do in a WHERE (fields being a certain value, etc.)
>
>So if I figured out part of this, sorry Tamar and Ted!!! Your record is still perfect...<g>
>
>Kevin
By jove, I think you've got it. Bottom line...use JOIN to connect tables, WHERE to filter the data.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer