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 derfloh 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. masha2008

    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...
  2. masha2008

    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...
  3. masha2008

    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...
  4. masha2008

    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" =...

Part and Inventory Search

Back
Top