Re: Dumb SQL Question

Posted in 1995

Catalin Badea — 5 Apr 1995 21:41:25 GMT — source: Informix-list mailing list archive (1991-1998)

TDRobinson (tdrobinson@aol.com) 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, : ... [snip] : on every row : print ??? detail, ??? detail [snip] Here's one solution using column aliases: select ... bill_complete.detail bill_detail, dist_method.detail dist_detail, ... on every row print bill_detail, dist_detail Catalin. -- _____ _____ _____ _____ _ _ _____ Catalin Badea _____/ _____/ _____/ _____/ _/_ _/ _____/ Senior Technical Architect _/ _/___ _/ _/____ _/_/ _/____ Tecsys Inc. _/ ____/ _/ _____/ _/ _____/ _/ _/____ _/___ ____/ _/ ____/ cat@tecsys.com _/ _____/ _____/ _____/ _/ _____/ include system "disclaim.4gh"