You have the following T-SQL statement. SELECT o.OrderNo, o.OrderDate, c.Address, c.City FROM Order AS o JOIN Customer AS c ON o.Customer = c.ID; What is the function of the ON clause?

The ON clause does not modify data; it is part of a SELECT statement's JOIN syntax and only evaluates a match condition - no DML operation occurs.

The ON clause specifies the join predicate that links rows from the Order table to rows in the Customer table. Here, it matches Order.Customer (foreign key) to Customer.ID (primary key), telling the database engine which rows from each table belong together in the result set.

Table aliases are defined using the AS keyword directly after the table name in the FROM or JOIN clause, not within the ON clause.

The ON clause performs no data modification on the Order table; it solely evaluates a Boolean condition to determine which rows to combine.