RE: SQL syntax

With afile as
(SELECT DISTINCT right(lpacct,4) as seed from badplpp)
Select seed FROM afile WHERE
seed between '7000' and '7999' and
seed not in (select qsssec from bsysqsp where qsssec =
seed) ORDER BY seed


Paul Therrien
Andeco Software, LLC
932 Saint Johns Dr
Maryville, TN 37801
225-229-2491
paultherrien@xxxxxxxxxxxxxxxxxx
www.andecosoftware.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of jmmckee
Sent: Friday, January 28, 2011 12:10 PM
To: Midrange Systems Technical Discussion
Subject: SQL syntax

This is definitely not coded in the best manner. It does work.

I am wondering: 1) How to remove the multiple references of right(lpacct,4)
and,
2) Can this thing be expressed in a "cleaner"
manner.

Query:

SELECT DISTINCT right(lpacct,4) as seed FROM badplpp WHERE
right(lpacct,4) >= '7000' and right(lpacct,4) < '8000' and
right(lpacct,4) not in (select qsssec from bsysqsp where qsssec =
right(lpacct,4)) ORDER BY right(lpacct,4)


Thanks.

John McKee