Test Data Management
- Test Data Management 10.5
- All Products
For example:SELECT <columns> FROM <table 1> INNER JOIN <table 2> ON <table 1>.<column_name> = <table 2>.<column_name>
SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date FROM suppliers, INNER JOIN orders ON suppliers.supplier_id = orders.supplier_id
For example:SELECT <columns> FROM <table 1> LEFT OUTER JOIN <table 2> ON <table 1>.<column_name> = <table 2>.<column_name>
SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date FROM suppliers LEFT OUTER JOIN orders ON suppliers.supplier_id = orders.supplier_id
For example:SELECT <columns> FROM <table 1> RIGHT OUTER JOIN <table 2> ON <table 1>.<column_name> = <table 2>.<column_name>
SELECT orders.order_id, orders.order_date, suppliers.supplier_name FROM suppliers RIGHT OUTER JOIN orders ON suppliers.supplier_id = orders.supplier_id
For example:SELECT <columns> FROM <table 1> FULL OUTER JOIN <table 2> ON <table 1>.<column_name> = <table 2>.<column_name>
SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date FROM suppliers FULL OUTER JOIN orders ON suppliers.supplier_id = orders.supplier_id