Dear experts -
I have a table with multiple deadline records per part.
The structure is like this:
TABLE 1 Project table
TABLE 2 Parts table
TABLE 3 Deadlines table (key field Part_ID - links back to Project_ID in first table).
NOW: i need to create a table with several fields from only the first record for each PROJECT in TABLE 3 when it is sorted in a given order.
Max on a field won't do it, since i need to grab other fields as well.
Do I need 2 queries, or can this be done in a single query?
I want to end up with something like this:
Table1.Project_ID Table3.deadline table3.deadlinename
one record for each project.