thanks for the prod, ron a little googling led me to this -- "Oracle does not support the optional AS keyword before a table alias" AS before a column alias appears to be fine ;o)