Thomas Good wrote:
>I have a query that looks up a patient's placement (which ward)
>in one table and then looks up diagnostic and demographic data
>in another...takes 53 seconds. Ouch.
>
>However, when I use table aliasing...the query output is on the
>screen *before* I submit the query. ;-)
>
>I'll send syntax, if you like.
Please do, to the list. I have never heard of 'table aliasing' and would
like to know more.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Give, and it shall be given unto you; good measure,
pressed down, and shaken together, and running over,
shall men pour into your lap. For by your standard of
measure it will be measured to in return."
Luke 6:38