What is the difference between a left join and a left outer join?

Question

I created 2 tables as

CREATE TABLE table1(customerName VARCHAR(20),custid NUMBER ,order_id NUMBER ,price NUMBER ); CREATE TABLE table2(id NUMBER ,salary NUMBER ); 

Now I tried to use queries

 SELECT t1.customername,t1.custid,t2.salary FROM table1 t1 left join table2 t2 ON t1.custid = t2.id; SELECT t1.customername,t1.custid,t2.salary FROM table1 t1 left outer join table2 t2 ON t1.custid = t2.id; 

But I get the same result. Is there any difference between them within their work? or both are the same !?

Answer 1

The OUTER keyword is optional for most popular SQL distributions, which means that there is no difference between LEFT JOIN and LEFT OUTER JOIN