Hi Sami Both do work separately. I changed the First and Last, still no help. If I change the first Browse to Select it works OK.
Strange thanks marc --- Sami Aaron <[EMAIL PROTECTED]> wrote: > Marc - > > My first thought is that both "FIRST" and "LAST" are > reserved words. Try > changing them to something else and see what > happens. > > Usually as I am debugging union select statements, I > make sure each one > works separately. > > Sami > > > ----- Original Message ----- > From: "marc" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, April 24, 2002 5:17 PM > Subject: problem with union > > > > > > Hi all > > > > I hate to ask but..... > > Can anyone tell me why this code causes RBase to > crash and > > kicks me out of RBW 6.5++ latest patch? > > > > browse t1.custnum=7 AS patnumber, t2.f_name=12 AS > FIRST, t2.l_name=12 + > > AS LAST,'Charges'=12 AS charges, > SUM(t1.ch_price) 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 all + > > select t1.custnum=7 AS patnumber,t2.f_name=12 AS > FIRST, t2.l_name=12 + > > AS LAST,'Payment'=12 as payment, > SUM(t1.ch_price) 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.ch_code > > > > Thanks > > marc > > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at > http://mail.yahoo.com > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO > rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to > [EMAIL PROTECTED] > > In the message body, put just two words: > UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO > rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to > [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE > rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ __________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
