> Hello Dynan, > > The tablename of PartnerLookup is a SQL alias. > Alias's are used frequently in all Database depenedent applications. > This isn't the correct answer. The "select" statements in Gentran are not just standard SQL. They are proprietary Gentran extended rules, and the PartnerLookup tablename is not a SQL alias. Aliases are used to simplify coding of long queries. PartnerLookup is even longer than Lookup_tb. Besides, Aliases cannot be used in a Gentran select command. The Gentran application integration users guide lists all the valid tablename entries for the select and update commands. You cannot just use standard SQL. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/OIFolB/TM --------------------------------------------------------------------~-> . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
