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 Wanet Telecoms Ltd 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. tkleader

    Select data from two tables

    Tab1 Data: UNAME AGR_NAME TCODE TTRAN F:AR_CLERK F.64 TTRAN F:AR_CLERK F-07 TTRAN F:AR_CLERK F-32 TTRAN F:AR_CLERK F-43 TTRAN F:AR_CLERK FB01 TTRAN F:AR_CLERK FB12 TTRAN F:AR_CLERK FB15 TTRAN F:AR_CLERK FB17 TTRAN F:AR_CLERK FBL5N TTRAN F:AR_CLERK FBP1 Tab2 Data...
  2. tkleader

    Upgrade procedure - Authorizations 3.1H to 4.6

    Johan, You can run su25 and it should have option for you to identify new transaction. The other way to find obselete transaction is through the release note. I just completed an upgrade for a major oil company. Here are some tips: 1. Redesign security to be Role-based. 2. Convert all...
  3. tkleader

    Select data from two tables with different column

    Ken, Thank you very much! It worked like a charm. Do you know of any website that teaches advance sql query.
  4. tkleader

    Select data from two tables with different column

    Tab1 has two columns (Last:First) and Tab2 has one column Name). What I want to do is select all data where Tab1.last = Tab2.name and Tab1.first = Tab2.name. Here are some sample data: Tab1.Last : Tab1.Last Doe : John Thomas : Barn Tab2.Name Doe John Jane Thomas Based on the...

Part and Inventory Search

Back
Top