Re: HELP!!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Simms (bob_simms_at_somewhere.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 21:36:21 +0100

"Chambers" <anonymous@discussions.microsoft.com> wrote in message
news:3564FA65-B638-415B-9806-362D5A3C8581@microsoft.com...
> Bob, much thanks to you, the script works perfectly. I did have select
within a select as you did, but you took it a step further using V and O.
What is V and O by the way? Are they virtual fields?

No, they are just aliases for the tables

FROM vehicles AS v

means that you can then refer to the vehicles table as v

Because we are referring to the vehicles table in the outer and inner SELECT
statements, we have to have give them different aliases so SQL knows which
one we are talking about. 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004