--- In ib-support@y..., "Surojit Niyogi" <saniyogi@m...> wrote:

> Hi,
>
> I'm having problems accessing particular columns in views. the view

consists of tables with columns that have the same name (i.e
Company.Phone, Users.Phone) with a synonym uPhone for Users.Phone and
just Phone for Company.Phone.

I see from other messages that you have resolved your specific
syntax problem.

I am curious, though, about why you had this problem in the first
place -- basically, I am wondering why you are using case-sensitive
names for the column names of this view (and for the name of the view
itself, for that matter)?

It appears that you do not use case-sensitive names throughout your
metadata (judging by your view definition further below, in which
names for the company and users tables are not case-sensitive), so why
did you use them for this view?

Are you trying to drive yourself crazy, or is there some other goal?

Just curious,
db

Metadata follows:

>
> The metadata for the view is shown below with the problems stated

after.

>
>
> CREATE VIEW "SUSERCOMPANY" (
> "COMPANY",
> "ADDRESS1",
> "ADDRESS2",
> "CITY",
> "STATE",
> "POSTAL",
> "COUNTRY",
> "WEBSITE",
> "DUNS",
> "EMPLOYEES",
> "PHONE",
> "FAX",
> "YEARSINOPERATION",
> "ISINVITEE",
> "USERID",
> "FIRSTNAME",
> "LASTNAME",
> "TITLE",
> "uPhone",
> "uFax",
> "EMAIL",
> "PASSWORDTEXT",
> "SUBSCRIBERLEVEL",
> "COMPANYID",
> "TOS",
> "TEMPID",
> "LASTLOGINTIME",
> "LASTLOGINIP",
> "LOGINID"
> ) AS
>
> SELECT Company.company, Company.address1,
> Company.address2, Company.city, Company.state,
> Company.postal, Company.country, Company.website,
> Company.duns, Company.employees, Company.phone,
> Company.fax, Company.YearsInOperation, Company.IsInvitee,
> Users.UserID, Users.firstname, Users.lastname, Users.title,
> Users.phone, Users.fax,
> Users.email,
> Users.passwordtext, Users.SubscriberLevel, Users.CompanyID,
> Users.TOS, Users.TempID, Users.LastLoginTime,
> Users.LastLoginIP, Users.LoginID
> FROM Company INNER JOIN
> Users ON Company.CompanyID = Users.CompanyID
> ;
>
>

<...>