Thanks everyone for your replies. I understand what the code is doing much better now. With a bit more help from GSquared, I got it working so that...

Thanks for the replies. So, because it's an inner SELECT that's pulling from the same table, I don't have to put in the FROM clause. That makes sense.

As...

Hi Wayne,

Thanks for the reply but that doesn't quite answer my question. The code works. What I'm trying to figure out is WHY it works so I can...

Taking your advice, I took another crack at taking it apart piece by piece. The code below is where I get lost as to why it's working when it...

A Happy Memorial Day to all y'all in the States. And a big THANK YOU! to all who have served. Enjoy your day!

Tom.Thomson (4/20/2011)

---

Brandie Tarvin (4/20/2011)

---

Terry Low-350996 (4/20/2011)

---

True story:

In a pre-SQL-geek incarnation I managed Food and retail sales at Anchorage International Airport. I had an employee(cashier) who was a 60+ yr old...

Moses supposes his toes are roses

As Moses supposes erroneously

Moses he knows his toes aren’t roses

As Moses supposes his toes to be

Smaug

Gail has been making noise about moving northwards (and Ireland definitely qualifies as northward).

Tornado Watch!

jcrawf02 (3/29/2011)

---

Stefan Krzywicki (3/29/2011)

---

jcrawf02 (3/29/2011)

---

So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming...

Tom.Thomson (3/26/2011)

---

Ray K (3/22/2011)

---

Just bring...

GSquared

---

…Had a copy of Paranoia, but couldn't convince anyone to let me either play or DM, probably out of some desperate need to retain a vestige of sanity on...

"Have Spacesuit, Will Travel" is one of my favorites. Try out "Citizen of the Galaxy" too. These books hooked me on Heinlein. While I really like "Starship...

Ah, so nice to know that Boston has retained the title of "Worst City to Drive In". My dad went to MIT in the early 60s and when he...