Re: Dumb SQL Question

Dear Tammi, The answer to your question is as follows: Use the alias feature of Informix to give the two columns new names - i.e. "select bill_complete.detail name1, dist_method.detail name2, ... from ... " Then use the alias names in your report as follows - "print ??? name1, ??? name2" Have fun! Tracy W. Nedd National Weather Service - DBA vball@skipper.ssmc.noaa.gov } } 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: } } select ... } bill_complete.detail, } dist_method.detail, } ... } from ..., } bill_complete, } dist_method, } ... } where ... and } .... } end } } format } } ... } } on every row } print ??? detail, ??? detail } } ... } } end } } } Thanks in advance for you help. } } Tammi }