I don't think "keft join" is the same as "left join". "select * from table1 keft join table2 using (somecol)" is an inner join of table1 and table2, but table1

I don't think "keft join" is the same as "left join". "select * from table1 keft join table2 using (somecol)" is an inner join of table1 and table2, but table1 is assigned the alias "keft", because "AS" between table and its alias is optional.