Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ChrisInNH

    Alias tables - getting same result for "name" despite use of alias

    Thank you for your efforts! I will continue my work - I'm quite certain I should be able to do this, and I'm betting it's something very simple getting in my way. Chris
  2. ChrisInNH

    Alias tables - getting same result for "name" despite use of alias

    Thanks again for your reply - sorry for the delay getting back. Here is a better layout of what I'm trying to do. Sorry if I over-explain: simplified table descriptions: F0101 - Address Book (in JDE, contains all entities: customers, employees, vendors, etc) AN8 - Address # (8N) ALPH -...
  3. ChrisInNH

    Alias tables - getting same result for "name" despite use of alias

    Thanks very much for the reply. For some reason, "Show SQL Query" is grayed out - not available to me. Relationship 1: Sold-to customer name from sales history to name, from F0101 Relationship 2: Sales Rep name for the customer, derived first by finding sales rep assigned (in F42140), then...
  4. ChrisInNH

    Alias tables - getting same result for "name" despite use of alias

    I'm new to this forum - apologies if I have missed an important protocol. Given rapid response from others to other posts here, I'm wondering if I have made an error with my post, its location or some other faux pas?
  5. ChrisInNH

    Alias tables - getting same result for "name" despite use of alias

    I'm not getting desired results for a situation where I need to report 2 separate entity names per row, where name for each comes from the same table. We're using JDE if that helps folks here so I'll illustrate: Report rows (and summaries, etc) need to have both Customer Name for sales history...

Part and Inventory Search

Back
Top