Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 53529 invoked from network); 10 Jul 2005 15:20:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 Jul 2005 15:20:21 -0000 Received: (qmail 96056 invoked by uid 500); 10 Jul 2005 15:20:20 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 95755 invoked by uid 500); 10 Jul 2005 15:20:18 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 95742 invoked by uid 99); 10 Jul 2005 15:20:18 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Jul 2005 08:20:18 -0700 X-ASF-Spam-Status: No, hits=1.0 required=10.0 tests=HTML_50_60,HTML_MESSAGE,RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com designates 64.233.184.194 as permitted sender) Received: from [64.233.184.194] (HELO wproxy.gmail.com) (64.233.184.194) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 10 Jul 2005 08:20:16 -0700 Received: by wproxy.gmail.com with SMTP id i32so699832wra for ; Sun, 10 Jul 2005 08:20:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=uCpWpoWon4AorkTJe5siyd2/HrX/2i5mD/tPwvYZOhr6XYf6aWB6Mo1o8tmHMqfxzPxUfEAh21AyvaAW3+c37w21hG0fxO1f4iSS1EpMiMCRYqJ6wo++OD8nl9EZhbFNvPhFGMRyqyBF1tCg9L83P4muc1L3IwM6sIyU4jutQmE= Received: by 10.54.36.15 with SMTP id j15mr1465209wrj; Sun, 10 Jul 2005 08:20:15 -0700 (PDT) Received: by 10.54.93.11 with HTTP; Sun, 10 Jul 2005 08:20:15 -0700 (PDT) Message-ID: <16178eb1050710082029032a74@mail.gmail.com> Date: Sun, 10 Jul 2005 09:20:15 -0600 From: Clinton Begin Reply-To: cbegin@ibatis.com To: user-java@ibatis.apache.org Subject: Re: Caused by: com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field In-Reply-To: <3DE6CB59-0587-481C-8E30-50274F7FE2EF@sun.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6699_27945160.1121008815185" References: <20050705192952.22400.qmail@web32807.mail.mud.yahoo.com> <3DE6CB59-0587-481C-8E30-50274F7FE2EF@sun.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_6699_27945160.1121008815185 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Looks like a mainframe conversion, possibly from a hierarchical DB. Possibl= y=20 an ERP system like SAP or JDE. Those are always nasty. Clinton On 7/9/05, Nathan Maves wrote: >=20 > just a thought but I would find and hurt the man who created these > tables... >=20 >=20 > On Jul 5, 2005, at 1:29 PM, Ashish Kulkarni wrote: >=20 > > Hi > > Thanks, it worked, i am using DB2 on AS400 as database > > for this query > > > > Ashish > > > > --- Larry Meadors wrote: > > > > > >> Any fields with # in them need to be escaped with ## > >> > >> A.PCVER# AS PCVER, > >> > >> - should be - > >> > >> A.PCVER## AS PCVER, > >> > >> > >> ..and... > >> > >> WHERE A.Pcpord =3D "VALUE# > >> > >> - should be - > >> > >> WHERE A.Pcpord =3D #VALUE# > >> > >> What db is this? That is a freaky looking join with > >> all the > >> (((((((((((((((( in there. > >> > >> Larry > >> > >> > >> On 7/5/05, Ashish Kulkarni > >> wrote: > >> > >>> Hi > >>> I am not sure why i am getting the above error, is > >>> there a way to debug it. > >>> I am going to paste my xml file definiation here, > >>> I am sure this SQL statement works > >>> the error i am getting is as below > >>> Caused by: > >>> > >> com.ibatis.sqlmap.client.SqlMapException: > >> > >>> Unrecognized parameter mapping field: ' F.P813NAME > >>> > >> AS > >> > >>> P813NAME' in AS BP2FAX, F.P813NAME AS P813NAME, > >>> F.P813PHON AS P813PHON, G.P830DESC AS P830DESC, > >>> A.PCSHPV AS PCSHPV, A.PCFRGT AS PCFRGT, A.PCORIG > >>> > >> AS > >> > >>> PCORIG, A.PCCURR AS PCCURR, A.PCEXCG AS PCEXCG, > >>> A.PCBUYR AS PCBUYR, A.PCBLOR AS PCBLOR, A.PCSRCE > >>> > >> AS > >> > >>> PCSRCE, A.PCVALU AS PCVALU, A.PCAKDT AS PCAKDT, > >>> A.PCVNDT AS PCVNDT, A.PCFXDT AS PCFXDT, A.PCINDT > >>> > >> AS > >> > >>> PCINDT, A.PCSPN1 AS PCSPN1, A.PCSPN2 AS PCSPN2, > >>> A.PCSPN3 AS PCSPN3, A.PCENDU AS PCENDU, A.PCUSF1 > >>> > >> AS > >> > >>> PCUSF1, A.PCUSF2 AS PCUSF2, A.PCUSF3 AS PCUSF3, > >>> A.PCSTAT AS PCSTAT, A.PCCANC AS PCCANC, A.PCVER > >>> > >>> > >>> my sql statement is as below > >>> > >>> SELECT A.PCPORD AS PCPORD , > >>> A.PCVALU AS PCVALU , > >>> A.PCPTYP AS PCPTYP , > >>> A.PCODAT AS PCODAT , > >>> A.PCVNDR AS PCVNDR , > >>> A.PCINVV AS PCINVV, > >>> A.PCSHPT AS PCSHPT, > >>> A.PCBILT AS PCBILT, > >>> A.PCCONF AS PCCONF, > >>> A.PCROUT AS PCROUT, > >>> A.PCASTA AS PCASTA, > >>> A.PCAPVU AS PCAPVU, > >>> A.PCAPVD AS PCAPVD, > >>> A.PCAPVT AS PCAPVT, > >>> A.PCPAYT AS PCPAYT, > >>> A.PCDISC AS PCDISC, > >>> C.P2FAX# AS BP2FAX, > >>> F.P813NAME AS P813NAME, > >>> F.P813PHON AS P813PHON, > >>> G.P830DESC AS P830DESC, > >>> A.PCSHPV AS PCSHPV, > >>> A.PCFRGT AS PCFRGT, > >>> A.PCORIG AS PCORIG, > >>> A.PCCURR AS PCCURR, > >>> A.PCEXCG AS PCEXCG, > >>> A.PCBUYR AS PCBUYR, > >>> A.PCBLOR AS PCBLOR, > >>> A.PCSRCE AS PCSRCE, > >>> A.PCVALU AS PCVALU, > >>> A.PCAKDT AS PCAKDT, > >>> A.PCVNDT AS PCVNDT, > >>> A.PCFXDT AS PCFXDT, > >>> A.PCINDT AS PCINDT, > >>> A.PCSPN1 AS PCSPN1, > >>> A.PCSPN2 AS PCSPN2, > >>> A.PCSPN3 AS PCSPN3, > >>> A.PCENDU AS PCENDU, > >>> A.PCUSF1 AS PCUSF1, > >>> A.PCUSF2 AS PCUSF2, > >>> A.PCUSF3 AS PCUSF3, > >>> A.PCSTAT AS PCSTAT, > >>> A.PCCANC AS PCCANC, > >>> A.PCVER# AS PCVER, > >>> A.PCINCO AS PCINCO, > >>> A.PCDATE AS PCDATE, > >>> A.PCTIME AS PCTIME, > >>> A.PCUSER AS PCUSER, > >>> H.P1NAME AS VP1NAME , > >>> H.P1ADR1 AS VP1ADR1 , > >>> H.P1ADR2 AS VP1ADR2 , > >>> H.P1ADR3 AS VP1ADR3 , > >>> H.P1COUN AS VP1COUN , > >>> H.P1PROV AS VP1PROV , > >>> H.P1CITY AS VP1CITY , > >>> H.P1STE AS VP1STE , > >>> H.P1CTRY AS VP1CTRY , > >>> H.P1ZIP AS VP1ZIP , > >>> H.P1TEL# AS VP1TEL , > >>> H.P1FAX# AS VP1FAX , > >>> H.P1MAIL AS VP1MAIL , > >>> H.P1CONT AS VP1CONT , > >>> A.PCSHPT AS PCSHPT, > >>> B.P2NAME AS SNAME, > >>> B.P2ADR1 AS SP2ADR1, > >>> B.P2ADR2 AS SP2ADR2, > >>> B.P2CITY AS SP2CITY, > >>> B.P2STE AS SP2STE , > >>> B.P2ZIP AS SP2ZIP , > >>> B.P2ATTN AS SP2ATTN, > >>> B.P2PHON AS SP2PHON, > >>> B.P2FAX# AS SP2FAX, > >>> C.P2NAME AS BNAME, > >>> C.P2ADR1 AS BP2ADR1, > >>> C.P2ADR2 AS BP2ADR2, > >>> C.P2CITY AS BP2CITY, > >>> C.P2STE AS BP2STE , > >>> C.P2ZIP AS BP2ZIP , > >>> C.P2ATTN AS BP2ATTN, > >>> C.P2PHON AS BP2PHON, > >>> D.P832DESC AS P832DESC, > >>> E.P834DESC AS P834DESC, > >>> J.PDLINE AS PDLINE , > >>> J.PDITEM AS PDITEM , > >>> K.M0DESC AS M0DESC , > >>> J.PDPUME AS PDPUME , > >>> J.PDREQ AS PDREQ , > >>> J.PDRQRD AS PDRQRD , > >>> J.PDRQST AS PDRQST, > >>> J.PDSETP AS PDSETP , > >>> J.PDQTYP AS PDQTYP , > >>> J.PDPRCE AS PDPRCE, > >>> I.SENAME AS SENAME, > >>> L.C803CNAM AS C803NAM, > >>> L.C803GSDS AS C803GSDS, > >>> M.P804DESC AS P804DESC, > >>> N.P039PORD AS P039PORD, > >>> N.P039POLN AS P039POLN, > >>> N.P039DSLN AS P039DSLN, > >>> N.P039QTY AS P039QTY , > >>> N.P039SHIP AS P039SHIP, > >>> N.P039DELV AS P039DELV, > >>> N.P039REQ AS P039REQ , > >>> N.P039COMM AS P039COMM, > >>> P.P2NAME AS PBNAME, > >>> P.P2ADR1 AS PBP2ADR1, > >>> P.P2ADR2 AS PBP2ADR2, > >>> P.P2CITY AS PBP2CITY, > >>> P.P2STE AS PBP2STE , > >>> P.P2ZIP AS PBP2ZIP , > >>> P.P2ATTN AS PBP2ATTN, > >>> P.P2PHON AS PBP2PHON, > >>> P.P2FAX# AS PBP2FAX, > >>> Q.P2NAME AS QBNAME, > >>> Q.P2ADR1 AS QBP2ADR1, > >>> Q.P2ADR2 AS QBP2ADR2, > >>> Q.P2CITY AS QBP2CITY, > >>> Q.P2STE AS QBP2STE , > >>> Q.P2ZIP AS QBP2ZIP , > >>> Q.P2ATTN AS QBP2ATTN, > >>> Q.P2PHON AS QBP2PHON, > >>> Q.P2FAX# AS QBP2FAX, > >>> R.SENAME AS RSENAME, > >>> S.SENAME AS SSENAME > >>> FROM > >>> > >>> > >>> > >>> (((((((((((((((( Pu1012 A left join pu1002 B on > >>> > >>> A.PcShpt =3D B.P2code ) Left join > >>> > >> Pu1002 C > >> > >>> on > >>> A.PcBilt =3D C.P2code ) Left Join > >>> > >> Pu1832 D > >> > >>> on > >>> A.PcShpv =3D D.P832Code ) Left join > >>> > >> Pu1834 E > >> > >>> on > >>> A.PcFRGT =3D E.P834Code ) Left join > >>> > >> PU1813 F > >> > >>> on > >>> A.PCBUYR =3D F.P813Code) Left join > >>> > >> PU1830 G > >> > >>> on > >>> A.PCPAYT =3D G.P830Code) Left join > >>> > >> PU1001 H > >> > >>> on > >>> A.PCVNDR =3D H.P1VNDR) Left join > >>> > >> SE1001 I > >> > >>> on > >>> A.PCAPVU =3D I.SEUSID) Left join > >>> > >> CF1803C L > >> > >>> on > >>> A.PCCOMP =3D L.C803COMP) Left join > >>> > >> PU1804 M > >> > >>> on > >>> A.PCptyp =3D M.p804code) Left join > >>> > >> pu1013 J > >> > >>> on > >>> A.pcpord =3D J.pdpord) Left join > >>> > >> pu1039 N > >> > >>> on > >>> J.pdpord =3D N.p039pord and > >>> > >>> J.pdline =3D N.p039poln) LEFT JOIN > >>> > >> PU1002 P > >> > >>> ON > >>> J.PDSHIP =3D P.P2CODE) LEFT JOIN > >>> > >> PU1002 Q > >> > >>> ON > >>> N.P039SHIP =3D Q.P2CODE) LEFT JOIN > >>> > >> SE1001 R > >> > >>> ON > >>> N.P039REQ =3D R.SEUSID) LEFT JOIN > >>> > >> SE1001 S > >> > >>> ON > >>> J.PDRQST =3D S.SEUSID), > >>> > >>> > >>> > >>> RS1002 K > >>> > >>> > >>> > >>> WHERE A.Pcpord =3D "VALUE# > >>> > >>> And A.Pcpord =3D J.pdpord > >>> > >>> AND J.PDITEM =3D K.M0CODE > >>> > >>> Order by PDLINE > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> __________________________________ > >>> Discover Yahoo! > >>> Use Yahoo! to plan a weekend, have fun online and > >>> > >> more. Check it out! > >> > >>> http://discover.yahoo.com/ > >>> > >>> > >> > >> > > > > > > > > > > __________________________________ > > Yahoo! Mail > > Stay connected, organized, and protected. Take the tour: > > http://tour.mail.yahoo.com/mailtour.html > > > > >=20 > ------=_Part_6699_27945160.1121008815185 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Looks like a mainframe conversion, possibly from a hierarchical DB.  P= ossibly an ERP system like SAP or JDE.

Those are always nasty.

Clinton

On 7/9/05, Nathan Maves <= Nathan.Maves@sun.com> wrote:
just a thought but I would find and hurt the man who created these
table= s...


On Jul 5, 2005, at 1:29 PM, Ashish Kulkarni wrote:

&= gt; Hi
> Thanks, it worked, i am using DB2 on AS400 as database
> for this query
>
> Ashish
>
> --- Larry Meador= s <larry.meadors@gmail.com> wrote:
>
>
>> Any fields with # in them need to = be escaped with ##
>>
>> A.PCVER# AS PCVER,
>>
>> &n= bsp;- should be -
>>
>> A.PCVER## AS PCVER,
>>>>
>> ..and...
>>
>>   &n= bsp;WHERE A.Pcpord  =3D "VALUE#
>>
>>  - should be -
>>
>>&n= bsp;   WHERE A.Pcpord  =3D #VALUE#
>>
= >> What db is this? That is a freaky looking join with
>> al= l the
>> (((((((((((((((( in there.
>>
>> Larry
>>
>>
>> On 7/5/0= 5, Ashish Kulkarni
>> <kulkarni_ash1312@yahoo.com> wrote:
>>
>>>= Hi
>>> I am not sure why i am getting the above error, is
>= >> there a way to debug it.
>>> I am going to paste my xm= l file definiation here,
>>> I am sure this SQL statement works
>>> the error i am getting is as below
>>> Caused = by:
>>>
>> com.ibatis.sqlmap.client.SqlMapException:>>
>>> Unrecognized parameter mapping field: ' F.P813NA= ME
>>>
>> AS
>>
>>> P813NAME' in&nb= sp; AS BP2FAX, F.P813NAME AS P813NAME,
>>> F.P813PHON AS P= 813PHON, G.P830DESC AS P830DESC,
>>> A.PCSHPV AS PCSHPV, A.PCFR= GT AS PCFRGT,=20 A.PCORIG
>>>
>> AS
>>
>>> PCORIG,= A.PCCURR AS PCCURR, A.PCEXCG AS PCEXCG,
>>> A.PCBUYR AS PCBUYR= , A.PCBLOR AS PCBLOR, A.PCSRCE
>>>
>> AS
>>
>>> PCSRCE, A.PCVALU AS PCVALU, A.PCAKDT AS PCAKDT,
>>= ;> A.PCVNDT AS PCVNDT, A.PCFXDT AS PCFXDT, A.PCINDT
>>>
&= gt;> AS
>>
>>> PCINDT, A.PCSPN1 AS PCSPN1, A.PCSPN2 AS PCSPN2,
>>> A.PCSPN3 AS PCSPN3, A.PCENDU AS PCENDU, A.PCUSF= 1
>>>
>> AS
>>
>>> PCUSF1, A.PCUS= F2 AS PCUSF2, A.PCUSF3 AS PCUSF3,
>>> A.PCSTAT AS PCSTAT, A.PCC= ANC AS PCCANC, A.PCVER
>>>
>>>
>>> my sql = statement is as below
>>>
>>> SELECT  A.P= CPORD  AS PCPORD  ,
>>>   &n= bsp;     A.PCVALU  AS PCVALU ,
>>>= ;        =20 A.PCPTYP  AS PCPTYP ,
>>>    &nbs= p;    A.PCODAT  AS PCODAT  ,
>>= >         A.PCVNDR  AS= PCVNDR  ,
>>>      &nb= sp;  A.PCINVV AS PCINVV,
>>>     =     A.PCSHPT AS PCSHPT,
>>>   &nb= sp;    =20 A.PCBILT AS PCBILT,
>>>      &nbs= p;  A.PCCONF AS PCCONF,
>>>     &= nbsp;   A.PCROUT AS PCROUT,
>>>   &nbs= p;     A.PCASTA AS PCASTA,
>>>  &= nbsp;      A.PCAPVU AS PCAPVU,
>>>&nbs= p;        A.PCAPVD AS PCAPVD,
>>>        = A.PCAPVT AS PCAPVT,
>>>      &nb= sp;  A.PCPAYT AS PCPAYT,
>>>     =     A.PCDISC AS PCDISC,
>>>   &nb= sp;     C.P2FAX# AS BP2FAX,
>>>  =        F.P813NAME AS P813NAME,
>>>       &nbs= p; F.P813PHON AS P813PHON,
>>>     &nb= sp;   G.P830DESC AS P830DESC,
>>>   &n= bsp;     A.PCSHPV AS PCSHPV,
>>>  = ;       A.PCFRGT AS PCFRGT,
>>>&n= bsp;       =20 A.PCORIG AS PCORIG,
>>>      &nbs= p;  A.PCCURR AS PCCURR,
>>> A.PCEXCG AS PCEXCG,
>>= ;> A.PCBUYR AS PCBUYR,
>>> A.PCBLOR AS PCBLOR,
>>&g= t; A.PCSRCE AS PCSRCE,
>>>=20 A.PCVALU AS PCVALU,
>>> A.PCAKDT AS PCAKDT,
>>> A.P= CVNDT AS PCVNDT,
>>> A.PCFXDT AS PCFXDT,
>>> A.PCIN= DT AS PCINDT,
>>> A.PCSPN1 AS PCSPN1,
>>> A.PCSPN2 AS PCSPN2,
>>> A.PCSPN3 AS PCSPN3,
>>> A.PCENDU AS= PCENDU,
>>> A.PCUSF1 AS PCUSF1,
>>> A.PCUSF2 AS PC= USF2,
>>> A.PCUSF3 AS PCUSF3,
>>> A.PCSTAT AS PCSTA= T,
>>> A.PCCANC AS PCCANC,
>>> A.PCVER# AS PCVER,
= >>> A.PCINCO AS PCINCO,
>>>  A.PCDATE AS PCD= ATE,
>>>  A.PCTIME AS PCTIME,
>>> &n= bsp;A.PCUSER AS PCUSER,
>>>  H.P1NAME  AS VP1NAME  ,
>= >>  H.P1ADR1  AS VP1ADR1 ,
>>> &= nbsp;H.P1ADR2  AS VP1ADR2 ,
>>>  H.P1ADR3&n= bsp; AS VP1ADR3 ,
>>>  H.P1COUN  AS VP= 1COUN ,
>>>  H.P1PROV   AS VP1PROV ,
>>>  H.P1CITY  AS = VP1CITY ,
>>>  H.P1STE   AS VP1STE &nb= sp;,
>>>  H.P1CTRY  AS VP1CTRY ,
>>= ;>  H.P1ZIP   AS VP1ZIP  ,
>>>=   H.P1TEL#  AS VP1TEL  ,
>>> = ;  H.P1FAX#  AS VP1FAX  ,
>>>  H.P1M= AIL  AS VP1MAIL ,
>>>  H.P1CONT  = AS VP1CONT ,
>>>  A.PCSHPT  AS PCSHPT,
&= gt;>>  B.P2NAME  AS SNAME,
>>> &= nbsp;B.P2ADR1 AS SP2ADR1,
>>>=20 B.P2ADR2 AS SP2ADR2,
>>> B.P2CITY AS SP2CITY,
>>> B= .P2STE  AS SP2STE ,
>>> B.P2ZIP  AS SP2ZIP = ,
>>> B.P2ATTN AS SP2ATTN,
>>> B.P2PHON AS SP2PHON,=
>>>=20 B.P2FAX# AS SP2FAX,
>>> C.P2NAME  AS BNAME,
>&g= t;> C.P2ADR1 AS BP2ADR1,
>>> C.P2ADR2 AS BP2ADR2,
>>= ;> C.P2CITY AS BP2CITY,
>>> C.P2STE  AS BP2STE ,>>> C.P2ZIP   AS BP2ZIP ,
>>> C.P2ATTN AS BP2ATTN,
>>>= ; C.P2PHON AS BP2PHON,
>>> D.P832DESC AS P832DESC,
>>&= gt; E.P834DESC AS P834DESC,
>>> J.PDLINE  AS PDLINE ,=
>>>=20 J.PDITEM  AS PDITEM ,
>>> K.M0DESC   AS M0D= ESC ,
>>> J.PDPUME  AS PDPUME ,
>>> J.PDR= EQ   AS PDREQ  ,
>>> J.PDRQRD  AS= PDRQRD ,
>>> J.PDRQST  AS PDRQST,
>>>=20 J.PDSETP  AS PDSETP ,
>>> J.PDQTYP  AS PDQT= YP ,
>>> J.PDPRCE  AS PDPRCE,
>>> I.SENAM= E   AS SENAME,
>>> L.C803CNAM AS C803NAM,
>>= > L.C803GSDS  AS C803GSDS,
>>>=20 M.P804DESC  AS P804DESC,
>>> N.P039PORD  AS= P039PORD,
>>> N.P039POLN  AS P039POLN,
>>&g= t; N.P039DSLN  AS P039DSLN,
>>> N.P039QTY  = AS P039QTY ,
>>> N.P039SHIP  AS P039SHIP,
>>> N.P039DELV  AS P039DELV,
>>> N.P039R= EQ   AS P039REQ ,
>>> N.P039COMM  AS P039CO= MM,
>>> P.P2NAME  AS PBNAME,
>>> P.P2ADR1= AS PBP2ADR1,
>>> P.P2ADR2 AS PBP2ADR2,
>>> P.P2CITY AS PBP2CITY,
>>> P.P2STE=   AS PBP2STE ,
>>> P.P2ZIP  AS PBP2ZIP ,>>> P.P2ATTN AS PBP2ATTN,
>>> P.P2PHON AS PBP2PHON,>>> P.P2FAX# AS PBP2FAX,
>>> Q.P2NAME  AS QBNAME,
>>>= Q.P2ADR1 AS QBP2ADR1,
>>> Q.P2ADR2 AS QBP2ADR2,
>>>= ;  Q.P2CITY AS QBP2CITY,
>>>  Q.P2STE =  AS QBP2STE ,
>>>   Q.P2ZIP  AS QBP2ZIP ,
>>>  Q.P2ATTN AS QBP2= ATTN,
>>>  Q.P2PHON AS QBP2PHON,
>>> = ; Q.P2FAX# AS QBP2FAX,
>>>  R.SENAME AS RSENAME,=
>>> S.SENAME AS SSENAME
>>>    = ;FROM
>>>
>>>
>>>
>>>  = ;(((((((((((((((( Pu1012 A left join pu1002 B on
>>>
>>= ;>           &nbs= p;A.PcShpt =3D B.P2code )   Left join
>>>
>>= Pu1002 C
>>
>>> on
>>>    &nbs= p;       A.PcBilt =3D C.P2code ) &n= bsp; Left Join
>>>
>> Pu1832 D
>>
>>= > on
>>>        &nbs= p;   A.PcShpv =3D D.P832Code ) Left join
>>>
>> Pu1834 E
>>
>>> on
>= ;>>           =  A.PcFRGT =3D E.P834Code ) Left join
>>>
>> PU181= 3 F
>>
>>> on
>>>    &= nbsp;        A.PCBUYR =3D F.P813Code)  Left join
>>>
>> P= U1830 G
>>
>>> on
>>>   &nb= sp;        A.PCPAYT =3D G.P830Code)=   Left join
>>>
>> PU1001 H
>>
&= gt;>> on
>>>          = ;  A.PCVNDR =3D H.P1VNDR)    Left join
>>>
>> = SE1001 I
>>
>>> on
>>>   &n= bsp;        A.PCAPVU =3D I.SEUSID)    Left join
>>>
>> = CF1803C L
>>
>>> on
>>>   &= nbsp;        A.PCCOMP =3D L.C803COM= P)  Left join
>>>
>> PU1804 M
>>>>> on
>>>          = ;  A.PCptyp =3D M.p804code)  Left join
>>><= br>>> pu1013 J
>>
>>> on
>>> &n= bsp;          A.pcpord =3D J.pdpord)    Left join
>>>
>> = pu1039 N
>>
>>> on
>>>   &n= bsp;        J.pdpord =3D N.p039pord=    and
>>>
>>>    &nb= sp;       J.pdline =3D N.p039poln) =  LEFT JOIN
>>>
>> PU1002 P
>>
>>> ON
>= ;>>           =  J.PDSHIP =3D P.P2CODE)    LEFT JOIN
>>>
>> = PU1002 Q
>>
>>> ON
>>>   &n= bsp;        N.P039SHIP =3D Q.P2CODE= )  LEFT JOIN
>>>
>> SE1001 R
>>
= >>> ON
>>>          = ;  N.P039REQ  =3D R.SEUSID)  LEFT JOIN
>>>
>> SE1001 S
>= >
>>> ON
>>>      =       J.PDRQST   =3D S.SEUSID),
= >>>
>>>
>>>
>>>  &nb= sp;        RS1002 K
>>>
>>>
>>>
>>>  = ;  WHERE A.Pcpord  =3D "VALUE#
>>>
= >>>      And A.Pcpord  =3D= J.pdpord
>>>
>>>     &nbs= p;AND J.PDITEM  =3D K.M0CODE
>>>
>>>      Order b= y   PDLINE
>>>
>>>
>>>
>= ;>>
>>>
>>>
>>>
>>>>>>
>>> __________________________________
>>> Discover Yahoo!
>>> Use Yahoo! to plan a weeke= nd, have fun online and
>>>
>> more. Check it out!
= >>
>>> http://disc= over.yahoo.com/
>>>
>>>
>>
>>
>
>= ;
>
>
> __________________________________
> Yahoo!= Mail
> Stay connected, organized, and protected. Take the tour:
> http://tour.mail.= yahoo.com/mailtour.html
>
>


------=_Part_6699_27945160.1121008815185--