Re: Dumb SQL Question
>From: tdrobinson@aol.com (TDRobinson)
>Date: 4 Apr 1995 16:01:28 -0400
>X-Informix-List-Id: <news.12737>
>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:
[Example compressed]
>select bill_complete.detail,
> dist_method.detail
>from bill_complete,
> dist_method
>where ...>
>on every row
> print ??? detail, ??? detail
Answer -- use display labels for the column names...
select bill_complete.detail bill_detail,
dist_method.detail dist_detail,
on every row
print bill_detail, dist_detail
Yours,
Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>