Gerard,
Keep in mind that table with alias assigned can be referenced in the query by alias only.
>Thanks Sergey.. I never realised you could do that !!
>
>>You can assign an alias to a table in a query. It can be done for readability and has to be done if you want to use the same table more than once in the query.
>>SELECT * FROM ccs c1 ;
>> ^ ^
>> | table alias
>> table name
>>
--sb--