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: *

  • Users: tkleader
  • Content: Threads
  • Order by date
  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

    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