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. tim44202

    Sub Query or Join

    no just a time table. Example: Dept Emp# Hours 10 123 12.5 15 222 5.0 20 123 6.5 10 333 14.1 18 444 40.0 If I want all time cards for employees who worked in Dept 10. I want: 10 123 12.5 20 123 6.5
  2. tim44202

    Sub Query or Join

    Since there is only one table I assume it joins to itself? How? Can you give me an example.
  3. tim44202

    Sub Query or Join

    I want to select all timecards for an employee only when the employee has at least one timecard in dept 100. The employee could work in an unlimited number of depts.

Part and Inventory Search

Back
Top