On readable SQL
>> My Version
>>
>> SELECT
>> p.project_name, s.staff_name, m.staff_name
>> FROM
>> project p JOIN
>> staff s ON s.staff_id = s.staff_id JOIN
>> staff m ON on m.staff_id = s.staff_id
An interesting style, I would have written it as...
select p.project_name, s.staff_name, m.staff_name
from project p
join staff s on s.staff_id = s.staff_id
join staff m on m.staff_id = s.staff_id
Shows the join statement relating to the table that does the join. I know,
the SELECT and FROM should be on their own lines, but I've got out of the
habit.
Steve
---------------------------------------------------------------------------
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"