Hi,

I once worked with a database where the table design (primary key in particular) had been made with alias's in mind. I really liked it and found it very useful to work with, and made deciding which alias to write very easy.

eg

SELECT

..

FROM

PATIENTS PATNT INNER JOIN

REFERRALS REFRL ON

PATNT.PATNT_REFNO = REFRL.REFRL_REFNO INNER JOIN

WARD_STAY SSTAY ON

PATNT.PATNT_REFNO = SSTAY.SSTAY_REFNO

Hope you get the drift.....