mercredi 6 juillet 2016

Can't make view from multiple table

I'm trying to learn about view in SQL. In my case, i can't execute statement to create view. Here is the statement: CREATE VIEW VTOTALMINUTESEMPLOYEE (EMPL_KODE, EMPL_NAME,DATE_IN, TIME_IN, TIME_OUT, HASIL) SELECT EMPLOYEE.EMPL_KODE, EMPLOYEE.EMPL_NAME, ATTANDENCE.DATE_IN, ATTANDENCE.TIME_IN, ATTANDENCE.TIME_OUT,((TIME_OUT-TIME_IN)/60) AS "RESULT" FROM EMPLOYEE JOIN ATTANDENCE ON EMPLOYEE.EMPL_KODE=ATTANDENCE.EMPL_KODE This is the errror code : SQL Message : -104 Invalid token Engine Code : 335544569 Engine Message : Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column 9 SELECT What's wrong with my code ? is there a thing that i missed ? i run the code with flamerobin. please help. Edit: I get following error: -104 Invalid token Engine Code : 335544569 Engine Message : Dynamic SQL Error SQL error code = -104 Token unknown - line 2, column 9 SELECT

Aucun commentaire:

Enregistrer un commentaire