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"

Reply via email to