Marc, I don't believe you can use Browse with the Union command.
Rich Starkey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of marc Sent: Wednesday, April 24, 2002 6:18 PM To: [EMAIL PROTECTED] 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/
