SELECT multiple columns from table with multiple lookups

SELECT multiple columns from table with multiple lookups

Hi,

I created a table with two lookup columns (these were the first two columns, and both had numerical values).

I then created a query table to select values from this table.

Simple selects of a single column worked ok:
select "ColumnName" from "TableName"

But selecting all or multiple columns threw an error message about illegal column names:
select * from "TableName"
or
select "ColumnName1", "ColumnName2" from "TableName"

The table names were all simple characters, nothing special.

The same kinds of SELECT statements worked on tables without lookup columns, and also on a table with one lookup column (as the second column).

My workaround was to recreate the table from scratch and replace the lookup clumns with normal columns (same names, same content, but just typed as "positive number"). But this means that the lookup-connection between my related tables is lost.

Thanks, Klaus Herrmanns