Ahhh, simpler than I thought :) Wasn't thinking about aliases :P Thanks.
----- Original Message -----
From: Stacey Verner <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 9:52 AM
Subject: RE: [DUG]: Join SQL?
> You need to alias staff twice.
>
> eg.
>
> select p.project_name, s.staff_name, m.staff_name
> from project p, staff s, staff m
> where s.staff_id = p.staff_id
> and m.staff_id = s.manager_id
---------------------------------------------------------------------------
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"