Hi Dennis Is I take the ' ' off I get illegal col name error.
thanks marc --- Dennis Fleming <[EMAIL PROTECTED]> wrote: > Why do you have quotes on 'Charges' and 'payments' > ??? > dennis > ***** > > > At 08:13 AM 10/9/2003 -0700, you wrote: > >Hi all > > > >Is there anything wrong with the code below? > >Sometimes it works OK in trace but crashes RBW when > >run in a command file. I have tried it on sever > data > >bases and the same results > > > >thanks marc > > > > > >BROWSE + > >t1.custnum=7 AS Pat#, t2.f_name=12 AS FIRST, > >t2.l_name=12 AS LAST,+ > >'Charges'=8 AS Service, SUM(t1.ch_price)=9 AS > Amount + > > FROM tran_daily t1,ptinfo t2 + > > WHERE t1.custnum = t2.custnum AND t1.tr_type = 1 + > > GROUP BY t1.custnum,t2.f_name,t2.l_name,t1.tr_type > + > >union select + > >t1.custnum=7 AS Pat#,t2.f_name=12 AS FIRST, > >t2.l_name=12 AS LAST,+ > >'payments'=8 AS Service, SUM(t1.ch_price)=S=9 AS > >Amount + > > FROM tran_daily t1,ptinfo t2 + > > WHERE t1.custnum = t2.custnum AND t1.tr_type = 2 + > > GROUP BY t1.custnum,t2.f_name,t2.l_name,t1.tr_type > > > > > >__________________________________ > >Do you Yahoo!? > >The New Yahoo! Shopping - with improved product > search > >http://shopping.yahoo.com > > > > > > > Dennis Fleming > IISCO > http://www.TheBestCMMS.com > Phone: 570 775-7593 > Fax: 570 775-9797 > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
