I'll admit, I was quite lost in class ever since we went into the lab and started doing SQL. I downloaded SecureShell and JEdit on to my personal computer, and proceded to work the problems through Chapter 4. The most confusing part of those 4 chapters was definitely the beginning of Chapter 4, with the IN and EXISTS operators and the nested subqueries. It seems much simpler to me to just connect tables using the WHERE clause. Maybe it's just me, but I would prefer to avoid subqueries as much as possible. And in a lot of cases, you can avoid them. I just don't see why someone would prefer to use one.
Comments