Date:         Tue, 5 Oct 2004 17:33:54 -0700
Reply-To:     Tony Wang <tonywolf@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tony Wang <tonywolf@YAHOO.COM>
Organization: http://groups.google.com
Subject:      What is wrong with this sql join?
Content-Type: text/plain; charset=ISO-8859-1

16   proc sql;
17   create table x.txunos_041005 as
18   select * from x.txunos_041005 a left join x.mbr_1 b on
19   a.trr_id=b.trrid and a.usrds_id=b.usrds_id;

ERROR: Integer divide by zero.
NOTE: The SAS System stopped processing this step because of errors.
ERROR:  Read Access Violation In Task ( SQL ]
Exception occurred at (67E691D3)
Task Traceback



What is wrong? nobody was reading that file.
How come "Integer divide by zero."?


Thanks,

Tony