I know I've asked this before, but I've plain forgotten what the syntax is.
Say I have two tables: staff, and project:
staff fields: staff_id, staff_name
project fields: project_id, project_name, staff_id, manager_id
Both staff_id and manager_id in project refer to a record in the staff
table. How can I do a join/lookup to return a result set with project_name,
staff_name, manager_name. But I'm stumped on the manager_name, I remember
doing this before but can;t for the life of me remember the join I need to
lookup into the same table...
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
