How is dot notation (.) used in SQL?
Why is the query below giving an error?
update Employee2
set Employee2.department = 'Marketing'
where Employee2.e_id=2;
Employee2 table:
Error:
[SQLITE_ERROR] SQL error or missing database (near ".": syntax error)
Employee2.department is probably causing the problem but not Employee2.e_id although both are dot notations.
