How to CREATE QUERY TO JOIN THE DATA (DRIVERID, NAME, HOURS_LOGGED, MILES_LOGGED),3.8 CREATE QUERY TO JOIN THE DATA (DRIVERID, NAME, HOURS_LOGGED, MILES_LOGGED)

[#1]

Encountered "Error while compiling statement FAILED: SemanticException [Error 10002]: Line 2:29 Invalid column reference 'total_hours' [ERROR_STATUS]

,

I encountered the Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 2:29 Invalid column reference 'total_hours' [ERROR_STATUS]

[#2]

Hi @Hak Tiong Ong,

Can you post the entire script you are running? I'm not seeing where you are referencing total_hours in what you have posted.

Thanks!

John

[#3]

Hi @jwhitmore

Found my mistake miss out the total_hours for the line below, thank you very much.

JOIN (SELECT driverId, sum(hours_logged)total_hours, sum(miles_logged)total_miles FROM timesheet GROUP BY driverId ) t 

[#4]

Excellent! Glad to hear it.