InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comFri, 05 Sep 2008 19:34:13 GMT20http://www.teradata.com/teradataforum/Topic10826-5-1.aspxYou posed the very same question on 3/6 and it was answered to your satisfation. Why are you asking the same questin again?http://www.teradata.com/teradataForum/Topic10827-9-1.aspxFri, 21 Mar 2008 17:52:32 GMTrgshttp://www.teradata.com/teradataforum/Topic10826-5-1.aspxAre you sure about your code ?I don't see any reference to A or B alias in the WHERE clause.Fri, 21 Mar 2008 11:42:01 GMTal1_24http://www.teradata.com/teradataforum/Topic10826-5-1.aspxHi all,I am trying to do a statement equivalent to the following one from Oracle;SELECT DISTINCT A.EMPLOYEE_NBRFROM EMPLOYEE_POSITION A, EMPLOYEE_POSITION_CTRL BWHERE (SELECT AVG(SALARY) FROM EMPLOYEE_POSITION) > ((SELECT AVG(SALARY) FROM EMPLOYEE_POSITION_CTRL) * .05)+ (SELECT AVG(SALARY) FROM EMPLOYEE_POSITION_CTRL)OR (SELECT AVG(SALARY) FROM EMPLOYEE_POSITION) < ((SELECT AVG(SALARY) FROM EMPLOYEE_POSITION_CTRL)-(SELECT AVG(SALARY) FROM EMPLOYEE_POSITION_CTRL) * .05)Basically I am trying to determine if the AVG of salary in table A is within 5 percent of table B. It works for all other db's but in TD i get errors and i've tried different things with no luck. The datatype is Float. If somebody could help me i would sincerely appreciate it, were turning our wheels here. For more info or to contact me directly please respond to this post.Thu, 06 Mar 2008 14:53:46 GMTmior66