Knowledge in FULL OUTER JOIN Syntax
SQL FULL OUTER JOIN Keyword
SQL FULL OUTER JOIN Keyword The FULL OUTER JOIN keyword return all records when there is a match in left (table1) or right (table2) table records. Note: FULL OUTER JOIN can potentially return very large result-sets! Tip: FULL OUTER JOIN and FULL JOIN are the same. FULL OUTER JOIN Syntax SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condition;
yash sharma
The SQL IN Operator
The SQL IN Operator The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions. IN Syntax SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...); or: SELECT column_name(s) FROM table_name WHERE column_name IN (SELECT STATEMENT);