Re: Dumb SQL Question

> > > On 4 Apr 1995, TDRobinson wrote: > > } 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 > } > } ... > > Tammi, I don't have ace on this machine but I always thought you could > print bill_complete.detail, dist_method.detail. > > Rgds Pete Why not select bill_complete.detail bcdetail, dist_method.detail dmdetail In other words use field aliasing in the select statement. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc