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 gkittelson 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. simmat

    join

    Hi, I am running a query that works as a subquery , but not as a join. Pls help: This one works: db2 => SELECT JOB FROM EMPLOYEE WHERE HIREDATE IN (SELECT MIN(HIREDATE) FROM EMP LOYEE) JOB -------- FIELDREP 1 record(s) selected. This one does not: select job from employee a , employee b...

Part and Inventory Search

Back
Top