Dumb SQL Question
> From: tdrobinson@aol.com (TDRobinson)
> Subject: Dumb SQL Question
>
> I am writing an ace report & there are two table with fields that have the
> same
> name, How do I print both fields? Below is an example of my code:
> [...]
> Thanks in advance for you help.
>
> Tammi
RTFM. As it plainly states (after only an hour of frustrated
searching) in the Informix SQL Reference Manual Supplement version 4.1
on page S-15:
You can avoid this ambiguity by including a table name with
the column name, as shown in the following example:
SELECT mytab.count FROM mytab
This was posted before in reference to a different topic, I think it
will work for you, too.
Good luck,
__________________________________________________________________
| Clem Akins Standard Disclaimers Apply |
|Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" |
| Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com |
|________________________________________________________________|