ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  SQL Subqueries
Subject:   subquery
Date:   2002-08-05 07:54:46
From:   jgconst
I have a database that is somewhat like a timesheet for employees. Let me give you an example, I have repeat entries with only the date as the primary key. So, I have id, name, address, phone, hours of work. There is an entry for each day they come to work for each employee. So, I want to get a list of all employees, the last day they worked, and all related data for that record. I have not had any sucess, please help. They are all on one table. I have used Order By "ID", "DATE" DESC, which sorts the table, so all I have to do is pull the distinct entry (but then I can't use Select * to see all my other fields. Do you have any suggestions?