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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with SQL
Im making a Join Select Table1 From Tables Where Table1=Table2 Table1 Table2 09876 Q9876 09871 Q9871 02345 Q2345 09867 Q9867 I need to join these two tables, and pull Table1, however I still need for that letter Q to be equal to '0' and I need to keep the zero...- masha2008
- Thread
- Replies: 1
- Forum: NCR: Teradata
-
SQL Help
Im making a Join Select Table1 From Tables Where Table1=Table2 Table1 Table2 09876 Q9876 09871 Q9871 02345 Q2345 09867 Q9867 I need to join these two tables, and pull Table1, however I still need for that letter Q to be equal to '0' and I need to keep the zero in...- masha2008
- Thread
- Replies: 0
- Forum: NCR: Teradata
-
Having a problem with a join
Im sorrry I didnt define T6 in FROM statement The code is like this select T1."ACCOUNT" "c1" , T4."ACCOUNT" "c5" , from "ACCT_DIM" T1, "ACCT_DIM" T4, "ACCT_GL_FACT" T6, where and T6."GL_ACCT_KEY" = T1."ACCT_KEY" and T6."ACL_ACCT_KEY" = T4."ACCT_KEY" and...- masha2008
- Post #3
- Forum: Cognos solutions
-
Having a problem with a join
Based on this SQL I have to make a report... select T1."ACCOUNT" "c1" , T4."ACCOUNT" "c5" , from "ACCT_DIM" T1, "ACCT_DIM" T4, where and T6."GL_ACCT_KEY" = T1."ACCT_KEY" and T6."ACL_ACCT_KEY" = T4."ACCT_KEY" and T4."ACCOUNT" =...- masha2008
- Thread
- Replies: 3
- Forum: Cognos solutions
