Revision history [back]

The method of determining the value in a column using JOIN outcomes is by using the SELECT statement with the JOIN keyword, specifying the tables to join and the conditions for the joining. Then, to determine the value in a column, you can specify the column name and the table name with a dot notation, such as tablename.columnname. For example:

SELECT orders.orderid, customers.customername FROM orders JOIN customers ON orders.customerid = customers.customerid;

This query will retrieve the orderid and customername columns from the orders and customers tables, respectively. The JOIN condition specifies that the records must match the customer_id column in both tables, so only the outcomes where the records match will be returned.