medu, thanks for your reply! Unfortunately, "date" as keyword and column name isn't the issue. (I didn't design this db - it was done by someone before me. I would not have used a keyword as a column name)
"select g1.date from glc g1" works, so the table-name alias works, and clearly the...