Difference From Standard SQL Query
- There is support for
LEFT OUTER JOIN but not RIGHT OUTER or FULL OUTER.
- To get equivalent output to
RIGHT OUTER you can reverse the order of the tables (i.e. A RIGHT JOIN B is the same as B LEFT JOIN A.
- While it isn’t required to complete this assignment, the equivalent to
FULL OUTER JOIN can be done by UNIONing RIGHT OUTER and LEFT OUTER
- There is no regex match (
~) tilde operator. You can use LIKE instead.
- There is no
ANY or ALL operator.
Insert
INSERT INTO table (column1,column2 ,..) VALUES( value1, value2 ,...);
Links