Error in Left Join

CrateDB SQL
1

Hi,

I am doing a left join in console.cratedb.cloud and I am encountering an error.

Query:
Select E.*
FROM “EMPLOYEE_1M” E
LEFT JOIN “DEDPARTMENT_1M” D ON D.ID_NUMBER = E.ID_NUMBER

Error: ColumnUnknownException(Column id_number unknown)

How to fix this error. Thanks.

2

Hi @Roi_Constantino,

did you model your column names to be uppercase? If yes, please try wrapping the column names in double quotes (LEFT JOIN "DEDPARTMENT_1M" D ON D."ID_NUMBER" = E."ID_NUMBER").

If not, can you share the table definitions, please (SHOW CREATE TABLE "EMPLOYEE_1M"; / SHOW CREATE TABLE "DEDPARTMENT_1M";)?