| Date: | Fri, 16 Mar 2001 14:43:13 -0700 |
|---|
| Reply-To: | DARRAN ZENGER <DZENGER@KLUNE.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | DARRAN ZENGER <DZENGER@KLUNE.COM> |
|---|
| Subject: | Re: SQL Question |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
I"d have to agree with Sigurd here on this one. The SELECT statement needs
the column clarified as he stated.
Darran Zenger
The SAS System
Programming
Klune Industries, INC
Spanish Fork Division
dzenger@klune.com
-----Original Message-----
From: Sigurd Hermansen [mailto:HERMANS1@WESTAT.COM]
Sent: Friday, March 16, 2001 2:19 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SQL Question
You are asking the SQL compiler to put all of the columns in the three
tables into table cc. In these cases you need to specify how to resolve
conflicts. For example, which of, say a.compid or b.compid, do you want to
have the name "compid". You could do this by replacing "*" with "a.*,c.*",
or (usually better) by specifying "a.compid as compid, b.compid as
compidb,....". Use aliases to resolve conflicts in names. Sig
-----Original Message-----
From: Rahul Chahal [mailto:rahulchahal@YAHOO.COM]
Sent: Friday, March 16, 2001 3:53 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SQL Question
6697 proc sql;
6698 create table cc as
6699 select distinct *
6700 from bb a, ts_comid b, xtax c
6701 where (a.compid=b.compid
6702 or c.ss_taxid=b.ss_taxid)
6703 and compid>'.';
ERROR: Ambiguous reference, column COMPID is in more than one table.
Could someone help with the error. Thanks in advance.
| 
