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/
