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
>>