<snip>
>>3. A matter of style - I'd find it easier to read if you were to use local aliases in your SELECTs.
>
>Do you mean I need to use aliases for my tables, such as Trans tr, Trans_Employees_Queues teg, etc.? Do you think it would improve readability?
As long as you use meaningfull aliases, the readability will improve. Compare
Trans_Employees_Queues.Some_Field = Employee_queue_schedules.Some_Other_Field
teq.Some_Field = eqs.Some_Other_Field
--sb--