Re: Dumb SQL Question
Quoting TDRobinson...
}
} 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
} ....
}
Tammy, use an alias...
select ...
bill_complete.detail bc_detail,
dist_method.detail dm_detail,
Now down in the FORMAT section print bc_detail and dm_detail.
DAS
--
Dave Snyder @ Bell Atlantic - Philadelphia, PA
WEB: http://www.ece.vill.edu/~dave/index.html
EMAIL: (w) ddx85qr@boots.bell-atl.com (h) dave@das13.snide.com